Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pass multiple tables to Access
Message
 
To
13/12/2005 12:28:15
Gary Otte
California Youth Authority
Sacramento, California, United States
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01077549
Message ID:
01077555
Views:
21
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform