Avoid locking for select request from access

  • Users with a special login are using access to read only the data.

    During this it lock some tables needed for a delete stored procedure

    it is possible to disable this lock to allow the delete to operate ?

    In settings or access ? or Sql Manager ?

    Actually we d'ont care that the data change although the user are consulting it.

  • you could use the nolock hint

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply