Access error "does not exist" for all queries

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

Guest

Approx 10 people in my office use an Access database from a shared drive,but
only one or two at a time. Two PCs always give the "Query does not exist"
error whenever a form or report runs off a query. The weird part is it use
to work just fine. What could be wrong? How can I troubleshoot this? From
the database window I can click on the query (it correctly lists all
queries), but then comes back and says query does not exist (but only on two
PCs). I need help with this and haven't found anything on the Internet.
Thanks, Laurie G
 
Laurie,
Is the database split into a frontend and back end? If so, does each user
have their own copy of the frontend on their own PC. If that is true, then
there may be something corrupt about those frontends.
 
Is your application split in FE/BE arhitecture?
If not, I would highly recommend you to do so - and I'm pretty sure that
will solve also your problem.
 
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

Parameter Value error in a Subform 0
Add autonumber to a large table? 0
Database does not work on xp 1
Access #Error & Excel Pivot 0
New Query, All Records in one Query, which does not exist in anoth 5
On Error not working 2
On Error not functioning 2
MS Access query filter problem 1

Back
Top