A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Unable to create forms in database



 
 
Thread Tools Display Modes
  #1  
Old January 9th, 2008, 06:53 PM posted to microsoft.public.access.forms
MRGBrandy
external usenet poster
 
Posts: 2
Default 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  
Old January 9th, 2008, 07:22 PM posted to microsoft.public.access.forms
George Nicholson
external usenet poster
 
Posts: 791
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:35 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.