G
Guest
I have an Access 2000 dbase shared among approximately 50 users. One
particular form bound to one large table (used by only about 15 users total),
constantly gets the "Can't Update, Currently Locked" error message.
I've searched these newsgroups and tried all the solutions that apply from
the (mostly older) posts and KB articles - to no avail. The database is
split (BE & FE are both run off the server though) and the problem has
recently become worse, meaning it happens once or twice a day. I have to get
everyone using that form out before the lock is released. I've even tried
getting the users out one by one to try and determine WHO had the lock and
what they may have done to cause it.
Could this be a "real" lock on the whole table/record/page in Access? It
seems to me it's got to be caused by something else. I suspect a "Duplicate
Record" button (created by the Access wizard) on that form may have something
to do with it. That's not a functionality *I* would have built into the
database but they rely upon it heavily now.
I've played with the record lock settings in the Options dialog endlessly to
no avail.
Any suggestions?
particular form bound to one large table (used by only about 15 users total),
constantly gets the "Can't Update, Currently Locked" error message.
I've searched these newsgroups and tried all the solutions that apply from
the (mostly older) posts and KB articles - to no avail. The database is
split (BE & FE are both run off the server though) and the problem has
recently become worse, meaning it happens once or twice a day. I have to get
everyone using that form out before the lock is released. I've even tried
getting the users out one by one to try and determine WHO had the lock and
what they may have done to cause it.
Could this be a "real" lock on the whole table/record/page in Access? It
seems to me it's got to be caused by something else. I suspect a "Duplicate
Record" button (created by the Access wizard) on that form may have something
to do with it. That's not a functionality *I* would have built into the
database but they rely upon it heavily now.
I've played with the record lock settings in the Options dialog endlessly to
no avail.
Any suggestions?