MSysDb

[Max]

Access 2000 format mdb got corrupted - could not export, compact, repair,
etc. Kept getting the message "Jet engine could not find file MSysDb." Could
not find this error in the KB.

Finally, restored from backup, but what is this error and can it be overcome?

Thanks in advance.

 

[Douglas J. Steele]

That's generally a sign that your database has been corrupted.

See what Tony Toews has at http://www.granite.ab.ca/access/corruptmdbs.htm

 

[John W. Vinson]

Access 2000 format mdb got corrupted - could not export, compact, repair,
etc. Kept getting the message "Jet engine could not find file MSysDb." Could
not find this error in the KB.

Finally, restored from backup, but what is this error and can it be overcome?

Thanks in advance.

MSysDB is one of the essential hidden system tables that Access uses to keep
track of everything in your database.

For reasons and prevention of corruption see
http://www.granite.ab.ca/access/corruptmdbs.htm

John W. Vinson [MVP]

 

[Guest]

That is, it is not an error. It is just a message. Jet can't find MSysDb.

MSysDb is an internal table that holds database properties, so Jet is
saying that it can't find the database (the file) that you have open.


application.dbengine.databases(0).collections("databases").documents("msysdb
").

msysdb is the document that contains the owner and permission id's, so you
can't open a database if Jet can't find msysdb.

Since Jet was originally a relational database system, all of these
collections and documents were probably originally conceived as
tables. I don't know what the internal representation is.

(david)