.ldb files don't appear to be working

[Guest]

Hi, We use Access in a multiuser environment, 4 users who are using Access
2002 sp2 and the Db's are maintained on a w2003 server. The users suddenly
are able to write to the some of the DB at the same time and ldb files are
visible in the folder where the Db are. The Db they can all write to at the
same time are the main Db that has links to the others and the most recent (
we have yearly DB ). Help!!!

 

[Rick Brandt]

Hi, We use Access in a multiuser environment, 4 users who are using
Access 2002 sp2 and the Db's are maintained on a w2003 server. The
users suddenly are able to write to the some of the DB at the same
time and ldb files are visible in the folder where the Db are. The Db
they can all write to at the same time are the main Db that has links
to the others and the most recent ( we have yearly DB ). Help!!!

The purpose of an LDB is not to prevent multiple users from editing at the
same time. It is for managing locks if more than one user tries to edit the
same *record* or data page of records if you are not using record-level
locking.

What type of locking do you have specified in your forms?