Write Conflict Error--Please Help!

[William Wisnieski]

Hello Everyone,

Access 2000 Issue

After about a month's worth of use, our multi-user database has started to
get the following error sporadically: "write conflict. this record has been
changed by another user since you started using it...." It happens when
more than one user is clicking on the "Next" button of a pop up form that
moves through a recordset. There are about 14,000 records in the main
table, the recordset returns whatever records were filtered based on certain
criteria.

The default record locking is set to no locks and "open databases using
record-level locking" is checked. I've tried splitting the database, but
that doesn't help.

This is really puzzling me because it's the second multi-user database I've
developed in Access 2000 where this problem occurs. It seems to happen when
the main table contains about 15,000 records. I don't recall this happening
in our Access 97 multi-user databases.

I was hoping to try to call Microsoft Advanced Support, but I could not
get approval for the $245 for the call! I sure do hope a Micrsoft MVP
is listening!

Any suggestions greatly appreciated.

Thanks,

William

 

[Nikos Yannacopoulos]

William,

"I've tried splitting the database, but that doesn't help."

Do you mean you have a monolithic multi-user database? I sure hope you're
backing up every night, 'cause that's a recipe for disaster! Corruption is
knocking on your door...
Do split it, and have each user run their own copy of the front end, locally
stored on their PC. Have a look at the access.multiuser newsgroup, you'll
find some helpful stuff in there.

HTH,
Nikos

 

[Tom Wickerath]

Hi William,

You might try implementing the code shown in this KB article, in order to achieve true record
level locking:

PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60
http://support.microsoft.com/?id=306435

When you split the database, make sure to place a copy of the front-end on each user's PC. Do
*not* share a single copy of the front-end database. Make sure that:

1.) All users have RWCD privileges on the folder where the back-end database is stored. See the
following KB article for more information:
Introduction to .ldb Files
http://support.microsoft.com/?id=208778

2.) The .LDB file is getting deleted properly when all users have exited the database.

There are many other considerations to keep in mind with a multi-user database, such as disabling
Name Autocorrect, setting SubDatasheets to None in all tables, maintaining a single connection,
proper indexing, etc. However, these issues affect the speed of a database--they do not affect
the records locked. If you'd like more information on these topics, then post back.

Tom
____________________________________


Hello Everyone,

Access 2000 Issue

After about a month's worth of use, our multi-user database has started to
get the following error sporadically: "write conflict. this record has been
changed by another user since you started using it...." It happens when
more than one user is clicking on the "Next" button of a pop up form that
moves through a recordset. There are about 14,000 records in the main
table, the recordset returns whatever records were filtered based on certain
criteria.

The default record locking is set to no locks and "open databases using
record-level locking" is checked. I've tried splitting the database, but
that doesn't help.

This is really puzzling me because it's the second multi-user database I've
developed in Access 2000 where this problem occurs. It seems to happen when
the main table contains about 15,000 records. I don't recall this happening
in our Access 97 multi-user databases.

I was hoping to try to call Microsoft Advanced Support, but I could not
get approval for the $245 for the call! I sure do hope a Micrsoft MVP
is listening!

Any suggestions greatly appreciated.

Thanks,

William