Forum Discussion
Microsoft Access Database App Error 3046
Help!!!
I have a multi user (front end / back end) access application.
My users are now receiving intermittent 3046 record currently locked error messages.
I have tried various regedit suggestions regarding file locks, buffer size but none work.
This problem started at the same time as the "Query Corrupt" issue (https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec) and I have a feeling its also linked to Microsoft attempts at fixing (https://support.office.com/en-gb/article/access-reports-that-databases-are-in-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d) issue.
Does anyone have any suggestions?
Thanks in advance
Following are the possible reasons that can result in the ‘Access database inconsistent state’ error:
If you’re using Data Access Objects (DAO) to open the database from VBA code, you can face the error code 3343 “Unrecognized database format error.”
If your database is stored on a network file share and is used by multiple database users simultaneously.
Read this articles: https://support.microsoft.com/en-us/topic/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec
(third party link removed by moderator)- Hi Stacy,
I fixed this problem by the shared references.
Julian-Cooper-KPP I concur with your evaluation. I am trying to find the update dates that precluded this issue, both in windows 10 and in Access 16. Our library keeps good copies of each update & want to to "get back" to where things were good. Can you supply accurate dates or build/update numbers? Thank you.
Since 10 January 2020, we got no errors again. Last week was a update for O365. Since this, we have the errors again. Not so much, but again.
- Shane Groff
Microsoft
Can you try closing all Office applications, and restarting Access to see if the issue goes away (you need to do this to pick up some configuration changes made on Friday that may be affecting this issue).We restart all Access applications on our clients and server. But yesterday and today we got the same errors 3046 at the most of the time and sometimes 3218.
- Hi Shane
Could you confirm, has an update been rolled out that may solve this?
What is the build number so can check if it's been installed?
Thanks- Shane Groff
Julian-Cooper-KPP There was no build update that would impact this, but there were configuration changes (each time Access starts, it downloads configuration changes that may change behavior) that were made on Jan 3 that might impact this.
We experience the exact same issue at one of our clients. They are using Access 2016 64 bits and first had the query issue, the update did fix that, but it seems as if the extreme amount of locking issues appeared shortly after.
They use a frontend separated from the backend.
- Repairing the databases does not help;
- Setting the registry key (lease time) as suggested as a work-around on the database server has no effect;
- Increasing the retry attempt from 2 to 20 has no effect.
- Disable opening the database in lock mode even does not resolve anything.
If the error occurs they could go to debug mode, wait a couple of seconds and resume by pressing F5, the "lock" then probably resolved and execution continues, but only for a while until the next lock hits.
This client is unable to work with more than 1 client at the moment. Any help or update on this will be highly appreciated.
I have myself experienced it quite regularly since December 10, 2019. I am in a multi-user environment, each user having its own copy of the same ACCESS 2016 program on his desktop running WINDOWS 10 while the data is in a separated ACCESS 2016 database on a server. The problem happens when the program just loaded tries to do a very simple update to one record of a table. This ACCESS program has been working fine for years and all of a sudden, the error 3046 appeared on December 10 exactly as described by others above. I have no idea if any patch has been developped for this but would like to know if any..
Yes, we have the same problem. Also since the the Bug "Query Corrupt".
Did you find any solution?
- Nothing concrete yet im afraid.
I have been playing with registry settings to no prevail.
Next test is to set FlushTransactionTimeout to zero top force asynchronous transactions but this may invariably slow the db down.We have updated our system up to 64 Bit, but there is the problem still active.
Most of the time we got the error 3046, sometimes we get error 3218.
We use Server 2012 as File Server. And 10 clients on Win10, O365, V1911 12228.2034. All 64 Bit.
It dosen't make any effect if we use DisableLeasing or not.
The problem exist since mid of December. Update KB4524445 was at the same time.
We need help, our company use Access as the only one ERP software.
Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Microsoft Access discussion space - please post Microsoft Access questions here in the future.
