consistent "can't find project or library" error

L

Laura

My agency uses a replicated Access97 database. One user
receives a "Can't find Project or Library" error each
time he tries to open a particular form until the follow
fix is applied:

Open a module, go into Tools->References, then add a
random reference, close the reference window, re-open the
reference window, delete the unnecessary reference, close
the reference window and module, and attempt to open the
form again (this time with success). The
references 'checked' in the reference window prior to any
modifications are the references needed and checked on
everyone else's copy of Access. None of the checked
references says 'MISSING', yet to get the references to
work correctly, each time this one user opens the
database, he must add and delete a random additional
reference before he can use a particular form.

This is a fix, but it's a nuisance since we have to
reapply the fix every morning. Any suggestions on how to
permanently fix the problem are very appreciated.

Thanks,
Laura
 
D

Douglas J. Steele

Does the user have his own copy of the database, or is everyone using the
same database? Your application should be split into a front-end (containing
the queries, forms, reports, macros and modules), linked to a back-end
(containing just the tables). Only the back-end should be on the server:
each user should have his/her own copy of the front-end, preferably on their
hard drive.
 

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

Top