Hi, can someone help me identify the source of this problem please? Each month I consolidate data in an .mdb and share it on a network drive. Our .mdb is way short of the personal geodatabase max limits so this should not be an issue and we have been using this method for years with no problems until the last 2 months. Now we are getting intermittent "failed to connect to database and unrecognized database format" errors. Our staff are working on various versions of ArcMap desktop from 10.3 to 10.7. The .mdb was in 9.2 and I have upgraded it but there are missing records when I try to export it. The upgrade did not seem to help but I've tried export to shape, .gdb, etc. but always get the same number of records upon export with a significant number missing. There are some old posts about repairing this in Access. Is this still the case? Anyone have any other ideas? I also have read where there might be some MS 32-bit vs Arc 64-bit conflicts but I need to retrieve the data from the .mdb. Thank you!
Hi Kristal
Since few years ago, Esri has stopped supporting Personal Geodatabases (mdbs). Instead, Esri recommends using File Geodatabases (gdbs) for simple workflows and local data management.
To share optimally your data across network and depending on the number of users and their workflows (query and / or edition), you should evaluate migrating to a Geodatabase Enterprise that adds more functionality and robustness to your system.
You can find more information here:
Enterprise geodatabases—Manage data | ArcGIS Enterprise
I can migrate it but there are still about 300 missing records. I've tried two different month's .mdbs and now going back to September to try to reload everything forward. Are there any best practices for sharing these .mdb over a network? Any known problems with new versions of Arc with .mdbs? We are just at a loss. Thank you.
I have not tried that but will now. Thank you!
Did you try to migrate your personal geodatabase to File geodatabase. Xander Bakker proposes a good solution in this blog.
how to convert mdb to gdb
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
