HPE Community
Operating System - Microsoft
1751690 Members
3253 Online
108781 Solutions
New Discussion

ACCESS-STORED PROCEDURES

 
SOLVED
Go to solution
Doug_85
Regular Advisor

‎09-07-2005 04:02 AM

‎09-07-2005 04:02 AM

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
0 Kudos
Reply
1 REPLY 1
Soujanya
Valued Contributor

‎09-07-2005 12:03 PM

‎09-07-2005 12:03 PM

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 :)
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.