By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,388 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

Record locking / update retries in Access 2007

P: n/a
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
Access.
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.