Cannot access stored procedures

  • Thread starter Thread starter Matthew Hansel
  • Start date Start date
M

Matthew Hansel

I have an Access ADP file that we have been using for quite a while
now. Over the course of the past weekend, we did a MAJOR
rebuild/upgrade/overhaul to our network, installing Windows 2003
Server, SQL 2000, etc. We have users that connect to the SQL database
via the ADP application. Now, the situation is that we originally
were running SQL 7. We did a backup of the DB file, and then restored
it to the SQL 2000 system. Now, the users that are connecting via
terminal services can get into the database after we modified the
connection settings, but when they click on one of the buttons for the
stored procedures from our "switchboard", it comes up with the
following error:
Microsoft Visual Basic

Run-time error: '7874':

Microsoft Access cannot find the object 'QueryDistArchived.'

END or DEBUG or HELP

Now, when I am logged into the server as admin, it works fine.

Please, we need to get this up and running as soon as possible - the
users of this database need this for their call lists.

Thank you,

Matthew Hansel
 
Probably not a heck of a lot of help, but if it was me, the first
thing I would do is completely open up the permissions on the query
and at least eliminate security as the cause.

Of course if it works you can start working on pinning down the
precise problem, and at least have people working in the meantime.

Peter
 
Back
Top