question

NirSegal-2977 avatar image
0 Votes"
NirSegal-2977 asked SunnyQi-MSFT commented

maxlocksperfile Error

Hello support team I have error appear on every second run "Maxlocksperfile" error windows 10 office 2016 access with VBA and DAO with microsoft office 16 library referance I change the registry from 9500 to 40000 and not help can you help?

windows-10-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Since your issue is more related to VBA and DAO which our windows-10-general forum doesn't focus on. I will add VBA related tag to see if there is any VBA support engineer can help. Thanks for your understanding.

0 Votes 0 ·

1 Answer

NirSegal-2977 avatar image
0 Votes"
NirSegal-2977 answered SunnyQi-MSFT commented

Hello SunnyQi-MSFT
Its looks that the problem is solved by VBA next command:
DAO.DBEngine.SetOption dbMaxLocksPerFile, 15000
Nir

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Nir,

Glad to hear that the issue has been resolved. You could accept the helpful answer as it would be helpful to anyone who encounters similar issues.

If there is anything else we can do for you, please feel free to post in the forum.

Best Regards,
Sunny

0 Votes 0 ·