1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Is it possible to access specific records without locking the whole table?.

Discussion in 'C#' started by giovax, Nov 19, 2007.

0
  1. #1
    Is it possible to access specific records from a Microsoft Access table without locking the whole table?. I have different processess accessing at the same time different records from the same table and I getting an execption, indicating the table is locked. Can any one provide me some help regarding how to access specifi records without locking the whole table in MS Access?
     
    giovax, Nov 19, 2007 IP
  2. orielo

    orielo Peon

    Messages:
    175
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #2
    actually,
    i had this problem a couple of years ago.
    sql server support a NOLOCK param, which you should use like so :
    Select * From Users (NOLOCK) where user_id='admin'
    Code (markup):
    gl.
     
    orielo, Nov 20, 2007 IP