MSysDb ERROR MESSAGE

[Guest]

I've experienced in many of my Access VBA projects the following error message:
"The Microsoft database Jet Engine could not find the object 'MSysDb'. Make
sure the object exists and that you spell its name and the path correctly."

When I get this message, I no longer can open the mdb file, in other words,
I've lost all my work and of course need to go to my backup filecopy.
Has anyone experienced this or no what I may be doing in code that causes
this?

Much thanks for any assistance.

 

[Guest]

Have you tried doing a "repair and compact". This menu option is under the
"Tools" menu, (in older version, it is only available when there is no db
currently open - if I remember correctly). Doing a R & C gives you the
option of saving the newly repaired & compacted db to a new file name,
preserving the old one "just in case". If you have tried this, then I'm not
sure what is going on.

 

[Guest]

That has happened to me before, and I did see that solution here on the forum
about repairing it. There was even a special repair program that was
technically better than the built in one, or designed to be used if you
couldn't get into the file at all. It is called: JETCOMP.EXE, but I forgot
exactly where it was located. I'm sure you can find it in a Search on the
MSDN site.

But, my question really is how can this corruption happen to an .MDE file,
which is what my users are using, and they each have a copy on their C:
drives?

Michael
-----------------------------------------------------------------------------------