How can I run a SQl Server 7 Store Procedure from MS Access?
Results 1 to 4 of 4
-
Lounger
- Join Date
- Jan 2001
- Posts
- 39
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-01-30 19:18SQL Server Strore Procedures (Access 2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Dec 2000
- Location
- Sacramento, California, USA
- Posts
- 16,775
- Thanks
- 0
- Thanked 1 Time in 1 Post
2002-01-30 20:07Re: SQL Server Strore Procedures (Access 2000)
From an MDB, you usually use ADO to run it. In an ADP you can run it directly. What exactly are you trying to do?
Charlotte
-
Lounger
- Join Date
- Jan 2001
- Posts
- 39
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-01-30 20:30Re: SQL Server Strore Procedures (Access 2000)
I want to create a form with some text box and pass the texbox value to the StoreProcedure and run it.
-
Plutonium Lounger
- Join Date
- Dec 2000
- Location
- Sacramento, California, USA
- Posts
- 16,775
- Thanks
- 0
- Thanked 1 Time in 1 Post
2002-01-31 07:14Re: SQL Server Strore Procedures (Access 2000)
What does the stored procedure do? You can build code to pass a parameter to a stored procedure, but what do you want to accomplish? And did you want to do this in an mdb or an adp?
Charlotte
