MSysDb - help 3

Max · External Since: Jun 28, 2004 Posts: 109

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.

John W. Vinson · External Since: Jan 29, 2004 Posts: 2693

On Mon, 23 Jul 2007 12:52:01 -0700, Max wrote:

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

Douglas J. Steele · External Since: Oct 07, 2003 Posts: 8178

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

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

"Max" wrote in message

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

david · External Since: Jun 22, 2005 Posts: 311

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)

"Max" wrote in message

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