Corrupted db

[PerryG]

I can't open my database....I keep getting the following message: The Microsoft Jet Engine couldn't find the 'MSysDb'....

Any ideas where I can find this or how to salvage my db?
Any and all help greatly appreciated.

 

[MIKElaw]

Check the Microsoft site for Jetcomp.exe

It compacts the target database externally and does allow you to get in again.

 

[PerryG]

Tried it, but it couldn't get in. Any other ideas? Appreciate the input.

 

[oharab]

You could try decompiling the file:
C:\[path to access.exe] [path to db.mdb] /decompile



failing that you need to go to a back up (you did take backups didn't you) or if it's important data then have a look ag

http://www.pksolutions.com

Sorry can't be or more help.

Ben ----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------

 

[PerryG]

I do have a backup from about 3 days prior (on my hard drive). This db was on the network.....the IT dept. might be able to recover the file from network backups, but it requires manager approval and a fee is assesed to our department. There were only a few files lost and all the source data is still available, so it can be reconstructed if necessary; just trying to save myself some work. I appreciate everyone's input. I might give the decompile a try and see what happens.

Thanks.
Perry

 

[MIKElaw]

Sorry JetComp didn't for you.

Have you tried the very simple? Create a blank database and import in what you can from the corrupted one. It sometimes works to varying degrees

 

[PerryG]

Yup, I tried the blank db. I can't get in because the MSysDb object from the corrupted database has gone missing. I'm not real sure what that is, but it must be really important.

Anyway, thanks again for everyone's help.

Perry