Unexpected State

[andyski101]

Ok, I know you guys have heard about this problem quiet a few times, my search told me that. But my problem has a bit of a twist. The message appeared when I tried to open the database yesterday, so I went to the backups and tried to open them. All the backups for the past month give the same message. The problem is with the FE only, the BE is working fine. The backups are connected to the same workgroup as the FE and BE. Has anyone seen this before and know what might of happened?

 

[andyski101]

Ok, well, the FE can now be opened when you log on as a read-only user. None of the admins can use their user names or passwords to get in. They all get the same error I did. Any advice would be greatly appreciated.

 

[The_Doc_Man]

Check for a "hung" LDB file ?

I.e. an LDB file that exists even if no one is in the corresponding db?

 

[andyski101]

I did a search and none were found.

 

[The_Doc_Man]

This is a stab, but you might try exporting the contents of the database to a freshly created MDB file and reconstituting your security on it.

Otherwise, you've got me stumped. (Not that it is so hard to do, you understand.)

 

[ghudson]

I would run the Jet Compact Utility on the front end and the back end. Sounds like one of the db's has a slight bit of corruption. The db's might open today but what about tomorrow?

Access 97: Updated Version of Microsoft Jet 3.5 Available for Download

Access 2000: Jet Compact Utility Available in Download Center

Access 2002: Jet Compact Utility Available in Download Center

 

[andyski101]

I have learned my lesson and repair and compact daily now. I have tried used the Jet Utility to no avail. I'll just have to work hard this weekend to get back as much as I can. Its not like I have anything better to do since I broke my bike again. Thanks for trying to help me; sometimes you just learn the hard way.

 

[mresann]

If the problem gets too hairy, and your company think it's worth it financially, you might go to this link.

Database Repair

This is the sponsor of the help forums, by the way.

 

[andyski101]

Thanks for the tip.