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?
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.