Error 3260 - Cannot Update record

[Cipriano Loera]

Please Help,

I have database that is heavily used for data entry. A
user will input info on a simple form that feeds to the
main table. 4 users access the database from our network
directory but 2 or 3 users will eventually recieve the
following message:

"Couldn't update; currently locked by user 'Admin' on
machine 'DTU301KN9XB269'."

Error 3260 according to MS Access 97

This error will continue to appear thru out time they are
entering, they can countinue after hitting OK but that
record will not save and thus giving us inaccurate
reporting.

Please let if know if thier is a solution or work around
for this. Also please let me know if more detail of the
problem is required.

Thanks Cipriano Loera Jr

 

[Tim Ferguson]

I have database that is heavily used for data entry. A
user will input info on a simple form that feeds to the
main table. 4 users access the database from our network
directory but 2 or 3 users will eventually recieve the
following message:

1: If any one of the users tries to modify an object in the mdb (such as
alter a table, design a form) Access will immediately claim exclusive use
and block other users. If you think about it, it could not really work any
other way, and A97 used to be highly prone to this kind of disaster.

2: To avoid this, make sure you are using a proper FrontEnd/ BackEnd split
database design. If all your users are interacting directly with the same
mdb file, you have a Corruption Waiting to Happen.

Hope that helps

Tim F

 

[John Vinson]

Please let if know if thier is a solution or work around
for this. Also please let me know if more detail of the
problem is required.

Split your database! Use Tools... Utilities... Database Splitter
Wizard.

This will put all the tables (and nothing else) into a shared backend
database on the server; each user should have their own copy of the
"frontend", a .mdb or .mde file containing the Forms, Queries, etc. on
their own computer, linked to the backend.