MSysDb

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Max - 23 Jul 2007 20:52 GMT

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.

Reply to this Message

Douglas J. Steele - 23 Jul 2007 22:08 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Access 2000 format mdb got corrupted - could not export, compact, repair,
> etc. Kept getting the message "Jet engine could not find file MSysDb."
[quoted text clipped - 5 lines]
>
> Thanks in advance.

Reply to this Message

John W. Vinson - 23 Jul 2007 22:24 GMT

>Access 2000 format mdb got corrupted - could not export, compact, repair,
>etc. Kept getting the message "Jet engine could not find file MSysDb." Could
[quoted text clipped - 3 lines]
>
>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]

Reply to this Message

david@epsomdotcomdotau - 24 Jul 2007 00:22 GMT

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)

> Access 2000 format mdb got corrupted - could not export, compact, repair,
> etc. Kept getting the message "Jet engine could not find file MSysDb." Could
[quoted text clipped - 3 lines]
>
> Thanks in advance.

Reply to this Message