By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

with (nolock) equivalent

P: 6
Is there a with (nolock) equivalent when writing queries in Access 2003?
Aug 10 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,669
Is there a with (nolock) equivalent when writing queries in Access 2003?
I don't think that there is with writing Queries directly, but if you create a Recordset based on the same Query, you can define No Locks (Optimistic Locking). Is this what you are referring to?
Aug 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.