Corrupt file

[Robbie G]

I have created a access database (and backed it up). A glitch on my PC meant
that I had to reinstall MS Office. Now I cannot open the database (or it's
backups); error message is "Unrecognised database format". Other .mdb files
open OK.

Any suggestions on how i could open this file or convert it to a different
format etc.

Thanks.

 

[Cheese_whiz]

Hi Robbie,

"Unrecognizable database format" sounds like you are trying to open a newer
file version with an older version of access. Do you have more than one
version of access on your computer? If so, try opening the older version of
access and then using the file>open to open the file in question. As always,
make a backup copy (or two) before trying any recovery suggestions.

CW

 

[Arvin Meyer [MVP]]

I have created a access database (and backed it up). A glitch on my PC
meant
that I had to reinstall MS Office. Now I cannot open the database (or it's
backups); error message is "Unrecognised database format". Other .mdb
files
open OK.

Any suggestions on how i could open this file or convert it to a different
format etc.

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Robbie G]

Thanks for this - i'll wirk through it!!

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

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

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Alan]

Hi Robbie,

You may try Advanced Access Repair at http://www.datanumen.com/aar/ This
tool is rather useful in salvaging damaged Access MDB files.

Alan

 

[Tony Toews [MVP]]

You may try Advanced Access Repair at http://www.datanumen.com/aar/ This
tool is rather useful in salvaging damaged Access MDB files.

You also work for that company. Posting without disclosing any
connection is highly unethical.

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's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David]

"Unrecognizable database format" sounds like you are trying to open a newer
file version with an older version of access. If your version is correct
then it means that your database file get corrupted. You need to take the
help of access repair software. You can download these software form
http://www.repair access-file.com
Hope it helps you


Gavid