.mdb Database

3 posts / 0 new
Last post
Anonymous Visitor
.mdb Database

Adding / deleting data, queries to the database - all worked fine.
Did compression base.
The resulting file compressed database turned 979 380 KB
When trying to open an empty boot Access, in the status bar says, "Done".
The base itself does not appear as if an empty Access launched.

What can be and how have still open the database?

Thank you.

   

hubby
Re: .mdb Database

Are you sure you are opening the right .MDB file? Back in the old days when I used Access a lot, the compression function would create a new DB file.
If you are opening the correct file and it is indeed empty, then something has gone haywire and you will likely have to revert to a backup file and try to compress it again - being sure to make a COPY of the backup file so you dont mess it up if something goes wrong again.

angellarson
Re: .mdb Database

First one apply short guide, second make use of https://www.openfiletool.com/mdbopen.html MDB Open File Tool

• Launch the Microsoft Access application, but do not try to open the corrupted MDB file.
• Go to "Tools" in the top menu bar, expand the "Database Utilities" submenu and select the "Compact and Repair Database" option if you are using Access 2002 or 2003. If you are using Access 2007 or 2010, you can find the "Compact and Repair Database" option by clicking the Microsoft Office button and going to the "Manage" menu.
• Highlight the MDB file that you want to restore and click the "Compact" button.
• Enter a name for a new database file, which will contain the restored data from the damaged MDB file.
• Navigate to the location on your hard drive where you want to save the restored version of the file.
• Click the "Save" button. Access will now compact and repair the MDB file and save a restored version in the location you selected.

Add new comment