RTE 3052, .update doesn't release a lock?

[twgonder]

Have you tried just using a query?

There is a query in the sample data base. It seems to work.


I'm testing the progress bar code with a sample DAO update.

[moke123]

Here, I did a simple database.
Just run the only procedure in the module.
Does it crash on other versions of Access?

Attachment 52156

worked for me. no errors

[twgonder]

worked for me. no errors

You ran the code in the sample db file as is?
Have you previously changed the registry to avoid the error?
What version of Access?

[ano]

run the update without ";" make all null
run several times the routine got 4
so example is ok na the real.
btw ?dbmaxlocksperfile is 62 and is not in my registry

[moke123]

You ran the code in the sample db file as is?
Have you previously changed the registry to avoid the error?
What version of Access?

Using O365.
Ran it as is.

Never changed the registry.

This issue has popped up in posts many times over the last 10 years or so.
The solution I believe has always been what I suggested in Post #2.
I don't recall if there was a max number of MaxLocks but IIRC 20,000 or so worked fine.

[orange]

Related to moke123's response/comments https://www.access-programmers.co.uk...r-file.296647/

[twgonder]

Thanks to those that tested. It still fails on my two laptops.
Adding an On Error Goto and a simple Resume in the error code allows the procedure to complete.
This is very odd, if some file sharing locks are set, and more are needed, then how does the procedure continue with just a Resume?

[ano]

no and its certainly not a parameter setting as suggested bec that par is 92 in ur example and no regedit set