Does MS Access support Nolock paremeter?

S

Shane Andrews

I believe you can find Lock settings in Options | Advanced section of
Microsoft Access 2007. Which version of Access is in question?
 
B

Banana

cgm said:
Does MS Access support Nolock paremeter?
Click to expand...

I believe this is a SQL Server-specific keyword.

But I do believe Access doesn't lock the records for read. By default,
it uses optimistic locking, meaning it request for lock when it attempt
to update, rather than soon as it is dirtied.

What prompted you to ask this? Normally, fiddling with Access's locking
behavior is almost never needed so there may be a better solution for
whatever problem you intended to solve with "NOLOCK".
 
B

Banana

Shane said:
I believe you can find Lock settings in Options | Advanced section of
Microsoft Access 2007. Which version of Access is in question?
Click to expand...

Be aware that though it says "No locks", it actually means optimistic
locking. In other words, it doesn't need to lock to read, but it will
attempt to lock when update request is issued.
 
Top