RecordLocks In Access - Stuck here.

[Aman J Singh]

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.

Thanks.

 

['69 Camaro]

Hi, Aman.

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.

Open the form in Design View and open the Properties dialog window. Select
the "Data" tab. Change the "Allow Filters" Property to Yes and change the
"Record Locks" Property to "No Locks." Save the form, close the Properties
dialog window, and open the form in Form View to test the changes.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.