topic Re: ACCESS-STORED PROCEDURES in Operating System - Microsoft

ACCESS-STORED PROCEDURES

Doug_85 — Wed, 07 Sep 2005 11:02:14 GMT

Using Access 2003 as the front end to MS SQL Server.
Having a brain cramp,

How do you use the stored procedure in SQL server through access?

If I have a stored procedure named movieavailability in SQL, how do I use this in a Access form or report to call up the proper records?

Thank you

Re: ACCESS-STORED PROCEDURES

Soujanya — Wed, 07 Sep 2005 19:03:57 GMT

Hello Doug,

The following article will demonstrate a simple method for executing stored procedures from Access

http://www.databasejournal.com/features/msaccess/article.php/3407531

Also refer to this weblink :

http://www.databasejournal.com/features/msaccess/article.php/10895_3363511_3

Good Luck :)