Restore Broken Database HELP!!!!!!!

[James Frater]

Hell All,

I'd added in an unbound text box with a minute() expression, when Access
closed itself.

I've tried to open it again and I get this message:

"Microsoft Access had detected corruption in this file. To try and repair
the corruption, first make a backup copy of the file. Then, on the Tools
menu, point to Databast Utilities and click Compact and Repair Database. If
you are currently trying to repair this corruption you will need to recreate
this file or restore it from a previous backup."

So, I have:

1) Created a copy
2) tried to use the MS Acess Compact and Repair option as mentioned above
but it gives me the same message.
3) tried to use the Jet Database Utility 4.0 from Microsoft, but this hasn't
helped either
4) Created a blank database and import tables but again I get the same error
message.

Any ideas folks?

cheers

JAMES

 

[Jerry Whittle]

At times like this, nothing beats a good backup. Do you have a recent backup
before the problem started?.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[a a r o n _ k e m p f]

if your database is too stupid to be stable, then move to SQL Server

seriously

 

[BruceM]

Ignore Aaron. He comes here to bash Access and attempt to spread incorrect
information for reasons known only to himself, if indeed they are known even
then.