Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Operating System - Microsoft
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 :)