RecordLocks In Access Still there even after putting No Locks

amanjsingh

New member
Local time
Today, 15:58
Joined
Feb 26, 2007
Messages
5
Hi,

I am completely new to Access. Here is something that I am experiencing...

I have this form and I search for candidate. Whatever results I get, I try to navigate from one to another and it gives me this error -

Access can't apply the filter because all records are locked.

I have set the Advanced Property (in Tools Menu --> Options) of Locking as No Lock but it is still the same. Please help.

I am just search records from a given table, and getting some records. I wnt to navigate those returned records from the original recordset. But when I navigate I get this error. That is when I jump frm one record to another (in the returned recordset) I get this error. Other wise, in the original set, it navigates fine.

Thanks.
 

Users who are viewing this thread

Back
Top Bottom