Cannot open database Error Message 3011 1

[Nicole]

I was attempting to back up a large database file (35,000 records) from my laptop to another computer over a network.  I copied the file from one computer and pasted into the other.  Played with it to be sure that it was ok, and everything was fine.  Then the next day I went to open the database from my laptop and got the error message:  "The Microsoft Jet database engine could not find the object 'MSysDb'.  Make sure the object exists and that you spell its name and the path name correctly."  I got this on the laptop and other computer.  I cannot open the database, import information from it, or anything else.  Basically 139MB of wasted space.  I'm DESPERATE!!!  I didn't have any "objects" that I know of (forms, reports, queries, etc.) named "MSysDb".  I can't understand why I get this message or how to get into my database.

 

[DougP]

Try this<br>Create a new .MDB<br>Then Click the Tables Tab <br>Then right click in the white space<br>and click Import<br>Find your bad .mdb<br>then see if you can import any of the tables from your corrupt .mdb<br>

 

[Nicole]

No, the same result.&nbsp;&nbsp;I get a message that says &quot;The Microsoft Jet database engine could not find the object 'MSysDb'.&nbsp;&nbsp;Make sure the object exists and that you spell its name and the path name correctly.&quot;&nbsp;&nbsp;<br><br>I don't know what this object is.&nbsp;&nbsp;It certainly is not anything that I created.&nbsp;&nbsp;And it's happening on both computers.&nbsp;&nbsp;I can't open the file, import from the file or do anything with it.&nbsp;&nbsp;Every attempt I make to get at this file, I get the same error message.<br>

 

[Nicole]

More info ... it seems that this MSysDb is some sort of system object.&nbsp;&nbsp;When I used the option to display hidden objects in my other databases, they all had the prefix &quot;MSys...&quot;&nbsp;&nbsp;But... here's the punchline, none had an object named &quot;MSysDb.&quot;&nbsp;&nbsp;How do I get into this database to get my VERY VALUABLE information.&nbsp;&nbsp;I can't open it, or import into Access, Excel or Quattro.&nbsp;&nbsp;Same error message no matter what I do.

 

[seaport]

I do not know the solution either but try to help.<br><br>If you open a database (say, Northwind.mdb) and open the system table MSysObjects, in the last record (at the bottom) of the table, you will see &quot;MSysDb&quot; in the field &quot;Name.&quot;

 

[elizabeth]

It does sound like your system tables are corrupted. If you are using Access97 and have not applied the Service Releases, you could try that and then running a compact on the database, or a copy of the database. SR1 or SR2 contains updated .dll's for Jet that combine the repair into the compact and have the ability to effect some repairs that earlier versions did not. If you have already appled the SR's or have Access 2000, I'm sorry to say I know of no other solution except the mantra often seen in this forum, &quot;Back up, back up, back up...&quot; Access is rather easily corrupted.

 

[JimConrad]

Just a thought...<br><br>Did you do anything to the System.MDA file? <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[JimConrad]

Take a look at this (from the Microsoft website):<br><br><A HREF="

http://support.microsoft.com/support/kb/articles/Q121/6/46.asp"

TARGET="_new">

http://support.microsoft.com/support/kb/articles/Q121/6/46.asp</A>

<p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[Nicole]

Not that I know of.&nbsp;&nbsp;I've called Microsoft Tech support, they don't know what it is.&nbsp;&nbsp;Last resort, I'm trying a professional.