Access error "does not exist" for all queries

L

Laurie G

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
 
L

Lynn Trapp

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.
 
A

Adrian Tofan

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.
 
Top