Unable to create forms in database

[MRGBrandy]

We recently upgraded from Office 97 to 2003. We have a database which
contains several forms/queries used by all. I run into problems when I am
trying to create a new form in a database that is being used by a coworker.
They are not accessing my form but one not connected. But I am getting the
following message. " you do not have exclusive access to teh database at
this time. If you proceed to make changes, you may not be able to save them
later." Is this a security setting that can be changed? This was never a
problem in the earlier versions of Access.

thanks

 

[George Nicholson]

All versions after 97 required exclusive rights to the mdb file when making
design changes to Forms.

Reason: to prevent database corruption. (Its for your own good, really.)

If a database is to be used by multiple people at the same time, the
database should be split into Frontend (forms, reports, queries, code) and
backend (data tables). *This is how Access was designed to be used by
multiple people simultaneously. Doing anything else will eventually corrupt
your database.* (not "might", "will")

http://www.granite.ab.ca/access/splitapp/index.htm
Splitting your Microsoft Access MDB into a front end and back end: Why?

The backend can be on a shared drive. Each user should have their own copy
of the frontend (local or shared drive, but their own copy). Design changes
are made to your copy of the frontend and then the update is distributed.

You should plan on how you intend to distribute updates upfront. There are
various methods. Here is one:

http://www.granite.ab.ca/access/autofe.htm
Auto FE Updater