consistent "can't find project or library" error

  • Thread starter Thread starter Laura
  • Start date Start date
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
 
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.
 
Back
Top