Microsoft 365 and Office | Access | For home | Other
A family of Microsoft relational database management systems designed for ease of use.
You will need an older version of Access to convert from a mdb form Access 2K.
MSO 365 Access database appears 1b corrupted
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have an Access 32 bit Single User mdb database that appears to be corrupted. Compact and Repair is not able to repair. The database is mission critical for me. Can anyone help?
Microsoft 365 and Office | Access | For home | Other
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
14 answers
Sort by: Most helpful
-
Anonymous
2024-10-22T15:28:33+00:00 When I open the database in this manner and open the startup form and other forms, it seems to run without let or hindrance, But, when I open the
That suggests that it's one of the objects in the database which is the source of the corruption. Importing all of the objects into a new empty .mdb file might eliminate the corruption. If the database is not already split into front and back ends, I'd strongly recommend that you do split it. This insulates the data from the interface objects in which corruption is more likely to arise. It also makes it easy to back up the data from within the front end. An illustration of how to do this can be found in BackupDemo.zip in the OneDrive folder to which I posted a link in my last reply, though only as a .accdb file.
Ken, I think I am able to identify the errant Form object and the code within the form causing the problem. When I try to edit the code, I am not able to save the edited code. Get the same two users trying to change the same data rubbish.
Mine is an Access 2000 mdb database. When I try to create a new database using MSO 365, I only get accdb Save As options for later Access versions. How do I create a new mdb database to import objects into?
Sorry to hassle you.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
ScottGem 68,830 Reputation points Volunteer Moderator2024-10-20T18:46:50+00:00 The database is mission critical for me.
I know this doesn't help and may be harsh.
But why would anyone run a mission critical application without regular backups and on 17 year old technology.
-
George Hepworth 22,855 Reputation points Volunteer Moderator2024-10-20T16:01:26+00:00 Restore the most recent backup of the database.
Is this the back end mdbor the front end mdb. If it's the back end, you will also have to manually recover any data added to the database since that last backup.
-
DBG 11,711 Reputation points Volunteer Moderator2024-10-20T15:35:10+00:00 I have an Access 32 bit Single User mdb database that appears to be corrupted. Compact and Repair is not able to repair. The database is mission critical for me. Can anyone help?
Do you have a backup copy?