MSysDb

M

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.
 
J

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]
 
G

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top