ACCESS-STORED PROCEDURES

[Doug_85]

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

[Soujanya · Accepted solution]

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 :)