Stored Procudures Support

[sujitopics]

Dear Friends,
Is MS Access Supports Stored Procedures ?
If anyone knows about this please share ur ideas
Thanks in Advance
Yours
Suji

 

[jitter]

If you are asking if Access can call stored procedures then Yes. You can use the ADO object to call a stored procedure in SQL Server.

 

[tlbroadbent]

You can also create pass-through queries that call stored procedures. See the following articles.

http://msdn.microsoft.com/library/e...ommandsMSAccessSqlDatabasePassthroughQueS.asp

http://support.microsoft.com/support/kb/articles/Q131/5/34.asp

http://support.microsoft.com/support/kb/articles/Q124/3/91.asp

http://support.microsoft.com/support/kb/articles/Q210/3/23.ASP

http://msdn.microsoft.com/library/en-us/acdata/ac_8_qd_12_3foz.asp

ADO:

http://support.microsoft.com/support/kb/articles/Q195/0/47.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Kdogg]

You Can also create an Access Project from your current database,Use Help to get more info on how to , which allows you to create your own stored procedures within the Access environment. An Access Project use's the same engine As SQL Server, Stored Procedures are native to SQL Server

 

[paron]

Update for those who bought into the "DAO is going away" thing. There is an ADO version at

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304323

Ron