I have an Microsoft Access application in which the main page is a form bound to the main table in the database (holding company information). This is a linked table to a SQL Server backend. There are approximately 40000 records in the database and multiple users.

Normally the form is opened without any filters.

There is a drop down list to find a specific company - which then re-opens the form with a where condition. Users tend to untoggle the filter button when they have finished working with the specific company.

I have discovered that Access takes out a shared Page Lock on the SQL Server table when no filter is in place. This can cause a problem when someone else is trying to update or insert a new record into the company table (they time out waiting for the shared lock to be released). Access removes the page lock as soon as any filtering takes place

I have also discovered that if I use the navigation button at the bottom of the form to go to the last record the page lock is released. 

Is there anyway I can programatically cause access to release this lock - I tried going to the last record in the on\_ApplyFilter event - but I presume (since you can cancel it) that this occurs before the filter is removed, not after.