cancel
Showing results for 
Search instead for 
Did you mean: 

ACCESS-STORED PROCEDURES

SOLVED
Go to solution
Doug_85
Regular Advisor

ACCESS-STORED PROCEDURES

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
1 REPLY
Soujanya
Valued Contributor
Solution

Re: ACCESS-STORED PROCEDURES

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