Help!

MSysDb - help 3

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Unique Constraint  
Author Message
Max
External


Since: Jun 28, 2004
Posts: 109



PostPosted: Mon Jul 23, 2007 4:52 pm    Post subject: MSysDb
Archived from groups: microsoft>public>access (more info?)

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.
Back to top
John W. Vinson
External


Since: Jan 29, 2004
Posts: 2693



PostPosted: Mon Jul 23, 2007 7:24 pm    Post subject: Re: MSysDb [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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]
Back to top
Douglas J. Steele
External


Since: Oct 07, 2003
Posts: 8178



PostPosted: Mon Jul 23, 2007 9:08 pm    Post subject: Re: MSysDb [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.
Back to top
david
External


Since: Jun 22, 2005
Posts: 311



PostPosted: Tue Jul 24, 2007 6:13 am    Post subject: Re: MSysDb [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum