Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2002-01-29 : 13:38:24
|
| Access 97. DB Works with no problem but when you try to repair the DB it fails and then you cannot open the DB any more. The repair fails with an error: "Unrecognized database format"The database does become corrupted when working with a query or two also. Is there a way to get around this or do I have to get this DB from the tape backup from a few days ago?DanielSQL Server DBA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-01-29 : 17:49:07
|
There is a nice super-duper repair utility that Microsoft has available for this:http://support.microsoft.com/default.aspx?scid=kb;en-us;Q172733It has saved my ass on more than one occasion.  Also read this, it covers some more options:http://support.microsoft.com/default.aspx?scid=kb;EN-US;q279334If any of this fails, you can also try creating a new blank database and importing everything into it. Sometimes you have to do this because the system tables in Access are FUBAR. Try importing all the queries, forms, reports, macros and modules first, then import the tables one-by-one.If the import fails for a certain table, it is almost certainly due to a corrupted memo field. You'll get an error like "Record not found" or something like it. Unless you can repair the original database and open it, you'll be SOL. If you do open it and you have a corrupted memo field (it will say "#Error" when you cursor by it), you'll have to delete the entire row. You can copy out all of the non-memo fields to another table, delete the row, then insert the row back into the original table. You will lose the memo contents though. |
 |
|
|
|
|
|
YIKES!!! DB Keeps corrupting!!!