Accessing SQL 2000 Stored Procedures from Access 2k

[SadOldGoth]

Hi Folks,

Is it possible to run the stored procedures in an SQL database from an Access2K database?

Many thanks,

Jes

 

[cmmrfrds]

Yes, you can run the stored procedures through VBA code or if you want as the row source in a Form or Report then make a pass-through query. The stored procedures can be directly used as the row source in an Access Project (adp) file.

 

[young]

Book "Access cookbook" page 647 teach you this topic. ISBN:0596000847