Can't open my project file (couldn't fine 'MSysDb')

Sokkheng

Member
Local time
Tomorrow, 06:54
Joined
Jul 12, 2023
Messages
40
I can't open my project file it always show the message as below
The Microsoft Access database engine could not find the object 'MSysDb', Make sure the object exists and that you spell its name and path name correctly.
my Microsoft Access file version 2019Pro Plus
How to solve this problem.
Thanks
Sokkheng
 
The database is corrupted. You can try a compact or a decompile. You can also try to import the objects into a new database. Otherwise, hope you have a backup.
 
I'm in full agreement with Pat.

The MSysxxx tables are internal system tables used to describe the database contents. If you are missing an MSys table you have a damaged database.

It is POSSIBLE to try to recover this. First make a copy of the file and put it aside in a safe place, because the recovery effort might destroy the file you are trying to recover. Once you have a copy you can try to do a Compact & Repair (C&R) by opening Access and directing it to do a C&R of the file in question. HOWEVER, I suspect that the C&R operation will fail because what it does requires it to open the file to examine the Access infrastructure. Which I suspect it cannot do.

Pat's second suggestion is a decompile. Instructions for that can found on the linked page. (Scroll down a little to find the DECOMPILE part.)


Again, I'm going to guess from that error message that your problem isn't compiled code but rather is damaged infrastructure. The bad news is that this might be unrecoverable, requiring you to step back to your last available backup copy. (Events like this are WHY you make backup copies.) If you have no backup copy, I hope you took good notes when you build the project because you'll be starting from scratch.
 
Last edited by a moderator:
I hope you have a good backup, 'cause you might need it. Good luck!
 
MSysDb is not a system table. It is a system object used to manage the database itself.

If it really is missing or corrupted, then your database cannot be recovered and a backup is your only possible solution
Neither compacting nor decompiling will be possible in this situation
 
I can't open my project file it always show the message as below
The Microsoft Access database engine could not find the object 'MSysDb', Make sure the object exists and that you spell its name and path name correctly.
my Microsoft Access file version 2019Pro Plus
How to solve this problem.
Thanks
Sokkheng
Try compacting and repairing the Access database. If that doesn't work, contact Microsoft support.
 

Users who are viewing this thread

Back
Top Bottom