Access Database is getting corrupt again and again

Can you give us examples of the types of queries that are associated with the problem?  That would be most helpful.

Hi George!

With a split database, I thought it was always best practice that everyone is using the same version of Access.

Regarding our database, we identified the string of queries/macros that were working just fine before the Microsoft update, but now would produce the inconsistent error, if the user initiating this was not the first one in the database. 

SO, we setup procedures so that before this set of queries/macros was initiated, all users' sessions would be closed, and the user initiating the process re-opened.  Others would be prevented from logging in until the process had completed.

Since it is something done usually first thing in the morning, it has worked out without much disruption.

There may be an occasional inconsistent error, but the above has remedied 95% of the problem for us.  (Use to be years between inconsistent errors)

Still looking for a resolution from Microsoft.  If anyone knows where or who we could send a split database sample, it demonstrates the issue as often as they would like to perform it.

Some of the speed problems reported here are not caused by this fix - they are just bad programming practices and are muddying the waters, preventing a genuine fix being adopted. 

Well, what can I say ?

Did you see any sample codes of this bad programing to share with us ?

But lets say you are right. And there is a bad programing with dlookups inside queries etc ...

Why with Server fix, this "bad programing" is performing faster than in client fix.

Doesn't this means that there are some speed issues with the solution of client fix ?

PS

Have to say that client fix is definately a fix and is working perfectly, just like the server fix.

And I personnaly insist that in many cases, described above, including JDBC connections, client fix is having speed issues and not always with bad programing. But if if works for you ... it is ok

Thanks mgnagle - Sounds like a good solution, but I'm not allowed to make registry fixes on users' laptops, which is why I'm trying to contact the right IT Support Dept in my company (Huge company). Once I can discuss your and others' fixes with this dept, I can get it reviewed, tested and implemented.

What are your thoughts on Access 2013 users still accessing an Access 2016 database, while mostly Access 2016 users are accessing the same database concurrently (backend db is on a network) ? Can this situation causing data corruption issues also ?

Save you business and your sanity by implementing the very simple CLIENT SIDE fix on EVERY window10 computer - windows 7/8 do not need it but you could also apply it to those without problems.  Some of the speed problems reported here are not caused by this fix - they are just bad programming practices and are muddying the waters, preventing a genuine fix being adopted. look back in the thread for the fix but here it is again for the 100th time on this stream.

Put the following into a .reg file and run it as Administrator on each Windows 10 computer accessing the databases. Reboot each. The corruption you are experiencing will be a thing of the past.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters]

"FileInfoCacheLifetime"=dword:00000000

"FileNotFoundCacheLifetime"=dword:00000000

"DirectoryCacheLifetime"=dword:00000000