Error when opening database

[JohnTAllen]

Everytime I try to open a certain Access database I get a message
saying "you do not have exclusive access to the database at this time.
If you proceed to make changes, you may not be able to save them
later.", I can click OK but it does it everytime and exactly 105 times
before I can get in. It appears that it is trying to open each object
on the form in design view. After I click through the message boxes 105
times everything works fine. It is a shared database so I know many
other users are accessing it at the same time. Hence the message about
"exclusive rights". Nobody else has this problem. Is it a setting on
the Access interface? Any ideas???? Oh and I can open other databases
on this same computer with no problem.

 

[Granny Spitz via AccessMonster.com]

Nobody else has this problem. Is it a setting on
the Access interface? Any ideas????

Remove the Adobe toolbar.

 

[Douglas J. Steele]

Nothing really comes to mind, other than to say that the application should
be split into a front-end (containing the queries, forms, reports, macros
and modules), linked to a back-end (containing the tables and
relationships). Only the back-end should be on the server: each user should
have his/her own copy of the front-end, preferably on his/her hard drive.

 

[JohnTAllen]

Thanks for responding. The database is currently split but both the
front and back end reside on the server at this time. The person who
made the database is still making modifications constantly. So at this
time it wouldn't be feasible to have the front end on each users
computer. With that said, do you think that when it is in a "finished"
state the front end should be on each users computer? If so, what are
the advantages of it? It the meantime, maybe I should try placing a
copy of the front end on my computer and using the linked table manager
and see if it works then.

 

[Douglas J. Steele]

Even if there are changes being made to the front-end, each user should have
his/her own copy now.

Take a look at the free Auto FE Updater Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm It will ensure that each user has
the most up-to-date version each time they open it. (It'll also help the
person who's making updates, since he/she will no longer have to wait until
no one's using the front-end before he/she can make changes)

 

[JohnTAllen]

I put a local copy of the front end on my computer and it worked fine
then. I will definately check out the auto front end updated in the
link you provided. It sounds like a great tool. Thanks for your help.