Locking of Access Database.

[Torpedo]

I have prepared an access database on a shared drive location(lan) with 5 tables. The main table has over 110 fields and is linked to a form. On an average the table stores 12000 records, which are updated via a form.

Normally, 7 users work on this form and do add/change/delete operations on the records.

The frequent issues I face are:
Corruption of records.
"Could not update, currently locked" errors.

I have constantly tried compact and repair option, but the same does not give required results.

Kindy advise a solution.

 

[John.Woody]

What version of access are you using? If it is 2k and you do not have the latest service pack on it (its either 2 or 3) then "Could not update currently locked by user..." is a known issue. Update all your PCs' with the latest SP.

 

[ghudson]

You will continue to have problems is the db is not split. Search the forum if you need more info on how to correctly setup a split db for multi user access.