UnFilter

[Rick West]

Access 2003 - In a form it allows filtering by a specific selection but I get the following error when trying to remove the filter:



"Microsoft Office 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 Option dialog box (Tools menu) is set to all records."

I have checked the specific form and the advanced tab record lock and both are set to No locks. I'm stumped.

[SoftwareMatters]

Did you create the database?
If not it is possible there is code somewhere e.g. running when the form opens that sets the record to lock.

[Rick West]

Yes, I created it. I have two databases almost exactly the same, both "shared" but churning different data. They both have the same forms in this part of the db and both forms are set to the same properties but the filter/remove filter (little funnel button) works in one db but not the other. Strange.

Reading about it on the internet tells me that if it is a shared db I have to "If you are working on a shared database, click Remove Filter/Sort on the Records menu to remove filters and then immediately update your view." to remove the filter.

But why does it work in one and not the other is where I'm stuck.