Thanks
Chey
It could be that someone else has it open at the same time, or other
possible issues.
What file locking is set up for that data?
Is it a split system with one back end file and a separate copy of a
front end file for each user on their own machine?
--
Joseph Meehan
Dia duit
This article might be helpful for you. It explains why all users must have
full privileges for the shared folder (Create, Read, Write & Delete):
Introduction to .ldb Files
http://support.microsoft.com/?id=299373
Also, is your database split, as Joseph indicated? Each user should have
their own copy of the front-end (FE) application on their own hard drive.
Here is an article that you might want to read. It includes a link that
explains the benefits of splitting:
Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html
Tom Wickerath, Microsoft Access MVP
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
From the help file of 2003 version:
When a user edits a record, Microsoft Access can automatically prevent
others from changing that record until the user has finished editing it.
Giving one user exclusive access to a record is called locking.
a.. Under Default record locking, do one of the following:
To prevent locking of records while you edit them, click No locks.
To lock all records in the form or datasheet (and the underlying tables)
while you edit them, click All records.
To lock only the record you're editing, click Edited record.
As I recall different version have slight variations in their record
locking. I believe that earlier version locked pages not records (see last
line of the help file information above). That might include more than one
record.