Record Locking Problem

  • Thread starter Thread starter Rob Wilson
  • Start date Start date
R

Rob Wilson

Access 2002, SQL 7. I have a form for executing the lookup of general
information of inventory parts. It is quite popular and may have 10 to
20 concurrent users.

The user enters the part number in an unbound combo box on the form.
The form is using a query that ties 2 linked tables from a legacy SQL
server database.

There is no need for the record to be locked this is just for the
viewing of record data, and this is my problem. The record queried is
being locked as long as the record is called up on the form. This is
causing other processes in the legacy system to lock until the record
is unlocked.

I have the select query properties set to no record locks. I have the
form set to no record locks, but I cannot set the form properties to
not allow edits because that prevents the user from interacting with
the combo box.

I would have thought that the no lock settings in the form and surely
the query would override the allow edit propterty in the form, but it
is not.

Can anyone help me with this catch-22 problem?

Thanks, Rob Wilson
 
As long as the form is bound to the SQL-Server table, the record, at the
very least, will be locked. Use a SQL statement to load a record to an
unbound form to avoid this behavior.
 
Back
Top