Totally stuck: Database possibly corrupted... 3

[kyjoey]

I am in a world of mess right now. I had a MS Access DB I used onlinje with a .ASP application. everything had been going great, until I opened the DB on the web server and started making changes while a user was writing to the DB. Now, I get this error:

"...mdb needs to be repaired or isnt a DB file". Then it prompts me to run the detect/repair wizrd and it does not work.

I have tried copying the DB to a local drive and nothing. This is critical I restore it. does anyone have any ideas??

Thanks all,

Joey

-Joey

 

[dhookom]

I would try create a new, blank mdb and copy import all the objects from the "suspect" mdb. Sometimes this might fail but also might tell you which object is suspect.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[JoeAtWork]

Decompiling might help:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /decompile "C:\MyDatabase.mdb

 

[psemianonymous]

Check the FAQ I link to below if the above tips don't work.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm