shared database problems

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I have an access database where 2 users work in it and
make changes at the same time. The only problem is that
the second person to open the database cannot save their
changes until the first person exits out. Is there a
setting that I am missing to allow both users to make
changes and saves while the other is in the database?
Thank You for the help.

Andy
 
And can I assume that the database is all contained in one file? This is a
big no-no for multi-user apps.

Running in this fashion can certanly cause locking issues and possible
corruption.

Please read up on "Split an Access Database" in Access Help.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Thank You kindly

andy
-----Original Message-----
And can I assume that the database is all contained in one file? This is a
big no-no for multi-user apps.

Running in this fashion can certanly cause locking issues and possible
corruption.

Please read up on "Split an Access Database" in Access Help.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm




.
Click to expand...
 
Hi,

Another issue you should look at is Record Locks property for your forms.
Take a look in the help file too
For multi-user applications, the most used approach is "No locks" (or 0
in VBa code)
This means optimistic locks
From the help:
"two or more users can edit the same record simultaneously. This is also
called "optimistic" locking. If two users attempt to save changes to the
same record, Microsoft Access displays a message to the user who tries to
save the record second. This user can then discard the record, copy the
record to the Clipboard, or replace the changes made by the other user"

Another option is All records: in this case, if a user open the form and
start editing, no other user can change the data (although they can view it)

And last one is Edited record.
From the help:
<<A page of records is locked as soon as any user starts editing any field
in the record and stays locked until the user moves to another record.
Consequently, a record can be edited by only one user at a time. This is
also called "pessimistic" locking.>>

For two users, there is not a real problem to have both app and data in the
same MDB. Although, as one said, splitting the application oin BE and FE is
a good practice, if you will want later to allow several users to use the
app simutaneously. And also, you should put the BE on a sharted newtork
drive, while keeping the FE on local HDD.

HTH,
Bogdan
 
Back
Top