Multi-user, cannot save edited form imiltaneously

  • Thread starter Thread starter Bon43
  • Start date Start date
B

Bon43

Hope someone can help. I don't know the exact error
message, however, I created a database wherein more than
one person can be working in a form at the same time.
There seems to be a conflict when one person tries to exit
or save a form, it won't let them until the other person
exits. What could this mean? We are using one database on
a server. Any help would be appreciated.
 
In a multi-user environment, you cannot edit/change most
components within a database when users are in it--you
must have exclusive access to affect any changes.
 
thanks for your reply. I have created databases in the
past, and have always been able to create new records
simultaneously.

The work around I thought of was replicating the database
for each user and linking tables, but the size of the
files would be huge.

I don't know how to restrict use to one user at a time,
could you enlighten me?

Thanks
 
Are you talking about making changes to the form design itself, or just
changes to data records displayed in the form?

Changes to the form design will require that other users not be in the same
database. But changes to the data in the tables can be done simultaneously
by multiple users.

If your tables (which store the actual data) are in the same database (.mdb
file) as the form, it may all be blocked. If you split the tables into a
separate database (the Back End) and link the tables from the database with
your form (the Front End), then everything works much more smoothly.
 
Check to be sure the 'Record Locks' property of your form
isn't set to 'All Records'.

How are you closing the form? It should be something like
the following...

DoCmd.Close acForm, "myForm", acSaveNo

The third parameter, acSaveNo, expressly says 'DO NOT SAVE
DESIGN CHANGES'. Good luck.
 
Back
Top