Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

an error can't get ride of !!!

Status
Not open for further replies.

zxmax

Technical User
Nov 24, 2003
179
CA
Greeting all,
I'm not sure how i create this error , but i can't get ride of it, it happens everytime i click the next or previous record in the bottom navigation buttons, or search for a record,
here is the error :
_______________________________________________________________
Microsoft access can't apply the filter because all the records are locked.

The recordLocks property of the form or report or the default Record Locking option on the Advanced tab of the Options dialog box (tools menu) is set to all Records

Reset the value to No Locks or Edited Record as appropriate.

______________________________________________________________

I doubled checked that propertites, and it is set to No Locks,

I'm not sure where else to check,
Any ideas of how to get ride of this message ?
thanks in advance
 
You said you checked the "Properties" but did you check the "Record Locking option on the Advanced tab of the Options dialog box (tools menu)?" Also, is this an app you built, or one you inheredied? The Properties may be Marked No Locks, but the records could be locked in code rather than the properties box. Hence the question about a db you didn't write.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top