Combo box query locks tables

  • Thread starter Thread starter Ron Hinds
  • Start date Start date
R

Ron Hinds

I'm upsizing an Access 97 app's backend to SQL server. On a form, I have
several combo boxes who's RowSource is set to an Access query. In code on
the form, I need to update a table but the update always ends in an ODBC
error - timeout. I used the sp_lock system stored procedure and discovered
that the tables are locked as soon as I load the form, and stay that way
until I unload the form. I tried setting various properties on the query -
Record Locks is set to No Locks, Recordset Type is set to Snapshot. Are
there any other properties I need to change? Is there a app level option I
need to set?
 
Back
Top