Record locking / update retries in Access 2007

[Cindy Huyser]

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