How do I run stored procedures in Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been using Access 2000 adp files with SQL Server 2000 for several years.
I just got a new computer with Access 2003 and I can't find where to run
stored procedures.
Is there a way to get stored procedures to appear in the Object bar in
Access 2003?
 
Stored procedures, views, and functions are all listed as "Queries" in an
Access 2003 ADP.
 
Create a blank project: File --> New File --> Project using existing data...

Once the new ADP file created and connected to a SQL-Server, running stored
procedures will be probably the same as with your old Access 2000 ADP file.
However, you may have security or permission problems.

Did you try opening your old A2000 ADP file?
 
You must log in or register to reply here.

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
From Access how to create stored procedure in SQL server 4
How do I use stored procedures in an accdb? 5
Using Stored Procedures With Access Data Project 2
Create Stored Procedure in SQL server from Access VBA? 4
ADP Access 2003 bug? 12
Stored Procedure not shown ? 1
Stored Procedure vs. View for Access 2

Back
Top