Forum Discussion

tecmetro's avatar
tecmetro
Copper Contributor
Sep 10, 2020
Solved

Trouble finding the trigger behind the "Unrecognized database format Access" error message?

We have multiple local users on my domain (around 6), accessing a Access Front End database split.
For most of the days, things go well, but sometimes, after some user updates some register, the .mdb file becomes corrupt, and everybody else using Access on their local PCs get the "Unrecognized database format" error message (see picture). So I have to restart the server, erase the .ldb temporary file and then click on "Compact and restore database"  option under Database Tools tab. That fixes the problem.

Microsoft 365 Access Build 16.0.3....

But what's the trigger? Is it a limitation of Access? Is there any way I can prevent this from happening?

Thanks in advance!

9 Replies

  • cjhickles's avatar
    cjhickles
    Copper Contributor

    I have a complex database with the tables sitting on a Server 2012 and mixed Windows 10/11 front-end users.

    When I get this issue, I found that copying the data tables down to a Windows 11 machine, repairing it then putting it back on the server works.

Resources