469,282 Members | 2,025 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Record locking / update retries in Access 2007

I have an Access 2000 database behind a threaded Java application that
that can have have concurrent access to the same table (but not the same
record). The database is set up for shared access with "No locks" as the
default, so that optimistic record locking should take place, and "Open
databases using record-level locking" is selected. Each Java thread gets
a new connection to the database, then updates its record.

One of my users has a system with Access 2007, and has intermittently
received Error -1102 from the ODBC Access driver ("Could not update;
currently locked by user 'admin' on machine 'XXX' ") when running this
application in scenario where updates to the same table (but not the
same record) by more than one thread are possible. I've verified that
only one update is handled per transaction.

So, I have three questions:
1) Where can I check the locking scheme and update retry specification
in Access 2007? Searches for "record locking" and "update retries" give
no useful result, and I haven't been able to find the interface that
corresponds to the Tools->Options->Advanced tab in earlier versions of
2) Where is the rumored option in Access 2007 to specify single record
locking (rather than the 2K or 4K page "record locking")?
3) Why would any record locking scheme (other than optimistic locking)
be executed by Access 2007 on a database created in an earlier version
of Access with "No Locks" specified?

Any insight into these questions would be a great help.

Thanks and best regards,
Cindy Huyser
Jun 22 '07 #1
0 3835

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Andy_Khosravi | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.