Are there any other options for repairing a db?

[Kelvin Beaton]

I have an Access 97 database that repair won't repair. It runs for a while
and then says it's either corrupt or not an Access db.

The file is about 400MB. I repaired and compacted it Sunday, but today the
server went down in the middle of the day and now I can't get into the file.

I ran repair at least a dozen times hoping it might repair a little more
each time and actually get all the way through.

I did try and link to it, but that doesn't work either.

Is there another repair tool other then what comes with Access 97?

Any input would be appreciated...

Thanks

Kelvin

 

[Luke Bellamy]

Hi Kelvin,
Try compacting with this tool:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q273/9/56.asp&NoWebContent=1
(beware of word-wrap breaking link)

This asks you for your mdb file to repair/compact and does so without
opening the file
in Access.

 

[Jim Carlock]

You can try this as well:
1) Create another mdb file (we'll call it NEWMDB.mdb)
2) Create links to the old mdb (whatever.mdb)
3) Create a make table query that uses the link to read the old table
4) NOTE: make sure you name the links appropriately, linkNames
and the new table appropriately, Names.

If that works, then you'll likely be able to identify which table has
the problems. You can also programatically recreate other objects,
by copying from the old mdb to the new mdb.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


"Kelvin Beaton" <kelvin at mccsa dot com> wrote in message
I have an Access 97 database that repair won't repair. It runs for a while
and then says it's either corrupt or not an Access db.

The file is about 400MB. I repaired and compacted it Sunday, but today the
server went down in the middle of the day and now I can't get into the file.

I ran repair at least a dozen times hoping it might repair a little more
each time and actually get all the way through.

I did try and link to it, but that doesn't work either.

Is there another repair tool other then what comes with Access 97?

Any input would be appreciated...

Thanks

Kelvin

 

[Tony Toews]

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q273/9/56.asp&NoWebContent=1

FWIW one new format to fetch a KB article is
http://support.microsoft.com/?kbid=273956

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

I have an Access 97 database that repair won't repair. It runs for a while
and then says it's either corrupt or not an Access db.

The file is about 400MB. I repaired and compacted it Sunday, but today the
server went down in the middle of the day and now I can't get into the file.

See the Access Corruptions FAQ at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm