Execute Stored Procedure

G

Guest

I have Access 2003 mdb file with linked data from SQL Server 2000. I have
created a stored procedure on the SQL server that manages role memebership
and data access. I am looking for help/article to assist me in creating the
connection string to the SQL Server and execute the stored procedure with
parameters from a form.

Thanks,
Shawn
 
D

David Lloyd

Shawn:

The following KB article may be useful.

http://support.microsoft.com/default.aspx?scid=kb;en-us;185125

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have Access 2003 mdb file with linked data from SQL Server 2000. I have
created a stored procedure on the SQL server that manages role memebership
and data access. I am looking for help/article to assist me in creating the
connection string to the SQL Server and execute the stored procedure with
parameters from a form.

Thanks,
Shawn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
SQL Server Stored Procedure timeout 3
Invalid Column Name Sql-Error :Executing a stored procedure 1
How do you call a stored procedure that returns a value? 3
sql stored procedure 1
Connection Failed SQLState: '28000' 2
How do you pass parameters to a stored procedure 2
Passing Paramaters when executing a Stored Procedure 1

Top