Sorry, I 've never tried this.  Why not post this in the DTS forum instead?

I think Embarcadero has a number of tools that can help you

I just tried a few tests to mirror your SP, and it appears that Access always generates the recordset from the first statement that creates a recordset. 

You're out of...

Ahah, I think I know the problem.  I use Ac2002, but that should not matter.  Go to Tools-->Options-->Advanced, and look at the setting for "Default File Format."  If it says...

I'm not sure what the problem is, but:

Try creating a blank Ac2003 ADP file, setting the connection to your database using the built-in ADP connection manager.

Then import all of your...

It's a bit difficult to get a handle on your code without knowing what it really does.  Without suggesting that you rewrite your SP to be more "strongly typed,"  I'll...

Glad to help, Paul.

You ask very good questions that are not really addressed well in the Help files.  So, keep 'em comin', and I'll try to help if I can (and if...

Marcel,

Please provide more details about the SP parameters (iinput and outut), and please post your VBA code that calls the SP.

Does the SP work when you double click it in...

"Using the GotFocus - I guessed - would save resources by giving only one combo a rowsource."

Actually, Access combo boxes queries do not get sent to SQL Server until the...

Every table needs a unique primary key.  This is the most fundamental rule of database design.

If you don't have this, forget about database programming, and forget about using Access -...

"However, it works excellently from the GotFocus."

I don't understand why you would want to send a query to SQL Server every time the user moves to the combo box.  Wouldn't...

"I havn't used Access for about 3 years, but one of the things it used to do, is download all the data of a linked table to a temp file...

"I have been putting the combo's Recordsource code in the On Open event of the form, not the On Click event of the combo - because for some reason I...

Hi Paul,

there appears to be a bit of disinformation here...

1) I think you are changing the wrong option - you are probably changing the option that controls the list drop downs...

Yes, there is no App.quit event, unfortunately.

Good Luck