RecordLocks In MS Access - Stuck here.?

Question

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.

MamaBean · Accepted Answer

The Options menu where you set No Lock is only the default. Forms can override the default setting in their properties. Go to your form's design view, and check the properties of the form by clicking the Form selector (square box at upper left corner of form) and then selecting View, Properties. In the Properties dialog, go to the Data tab and check the Record Locks property - it should be set to All Records. Check the other properties here as well - e.g. if you are using a filter, the Allow Filters property should be set to Yes.

meg · Answer

which language are you using as frontend?....

if you are using VB or ASP just check with the lock type that you have provided with the recordset....

or try copying your access table to a new database and save it with a different name...

also scan your computer for virus...there is a possibility that a virus might be locking your file

Trending News

RecordLocks In MS Access - Stuck here.?

2 Answers