Problems with Access 2003 ADP

R

routergal

Joined
Nov 10, 2009
Messages
4
Reaction score
0
hello everyone,

I have completed my vacation database with an Access 2003 front-end and SQL 2000 back-end. I now have to set up the Access front-end on multiple users desktops. I have connected ODBC and SQL is connecting without a hitch. The problem is on my forms that run stored procedures. Anyone heard of this...the stored procedure works fine in the queries tab, however when being run from a form it does not find the stored procedure.

Any help would be greatly appreciated.

Lucinda
 

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
Stored procedure as row source for a combo box 4
Access 2000 ADP and SQL Server 2005 2
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
SPs vs. Views 2
Adodb connection to different SQL SERVER DB 3
Converting Application from ADP to ACCDB 11
Queries missing in ADP and SQL after upsizing 4

Top