If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unable to create forms in database
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 |
#2
|
|||
|
|||
Unable to create forms in database
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 -- HTH, George "MRGBrandy" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|