Multiple users concurrent saving of different records in Access 2

[CamieG]

Have 4 users signed on to Access 2002 db. They need to be able to change
certain date information via same form throughout the day. Program will not
enable them to save even though Tools, Advanced setting is set up to share
and records are not locked. What is missing?

 

[John W. Vinson]

Have 4 users signed on to Access 2002 db. They need to be able to change
certain date information via same form throughout the day. Program will not
enable them to save even though Tools, Advanced setting is set up to share
and records are not locked. What is missing?

What's the Recordsource of the form? If it's not updateable, the form won't be
either.

Please post the SQL view of the recordsource query if that seems to be the
problem.

Also of course check that the form's Allow Updates property is Yes, and that
the date control is bound to a table field and is Enabled and not Locked.

 

[CamieG]

Recordsource is a query built from the table. Query reflects only active
program participants - not inactive participants. Properties show that edits
are allowed on the forms.
When I created the database I did so on my local drive. I then moved it to
a shared drive so that others in my workgroup could access this. Now, today,
unlike before, only one of us can be in the database at the same time. It
locks the others out. Not sure what has changed since I have not changed
anything and we were all able to view the forms before - just not save
changes.

 

[John W. Vinson]

Recordsource is a query built from the table. Query reflects only active
program participants - not inactive participants. Properties show that edits
are allowed on the forms.
When I created the database I did so on my local drive. I then moved it to
a shared drive so that others in my workgroup could access this. Now, today,
unlike before, only one of us can be in the database at the same time. It
locks the others out. Not sure what has changed since I have not changed
anything and we were all able to view the forms before - just not save
changes.

If it's a shared multiuser database you should - MUST!!! - split the database
into a "backend" containing only tables, and a Frontend containing all the
forms, queries, reports etc. Each user should have their own private copy of
the frontend.

See http://www.granite.ab.ca/access/splitapp.htm for a thorough discussion.