I didn't try to compact via vba code. I opened up MS Access and went to Tools/Database Utilities and selected Compact/Repair and then selected the database.
I have tried to get the tables and queries by using another database and I cannot connect. I have tried to open exclusively and that...
easyit: I tried the decompile already and I receive the error that the database is in an unexpected state. I am trying all of the suggestions on a backup of the corrupted database.
BBaggins: The database version was 2002-2003 prior to this problem. The problem happened when I did a...
There was some code in one of the links that advised how to import the tables and querys from the corrupt database. The code is below:
Option Compare Database
Sub RecoverCorruptDB()
Dim dbCorrupt As DAO.Database
Dim dbCurrent As DAO.Database
Dim td As DAO.TableDef...
I receive the following error when trying to open up an Access Database:
This database is in an unexpected state: Microsoft Office Access can't open it.
This database has been converted from a prior version of Microsoft Office Access by using the DAO CompactDatabase method instead of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.