>Is it possible to pass multiple tables from a SQL server stored procedure to Microsoft Access? If so, what does the syntax look like?
>
>TIA,
>Gary
I think (not sure) that this is an Access issue. Is the Access can handle many record sets created in SP? I never worked with Access so I can't be in help here. In VFP (what I use) I can get more than one recordset from SP using SQL PassThrough.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.