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 - 25 Aug 2007 12:10 GMT
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
> 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
[quoted text clipped - 5 lines]
>
> Thanks.
Arvin Meyer [MVP] - 25 Aug 2007 14:59 GMT
>I have created a access database (and backed it up). A glitch on my PC
>meant
[quoted text clipped - 5 lines]
> 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

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Robbie G - 26 Aug 2007 12:38 GMT
Thanks for this - i'll wirk through it!!
> >I have created a access database (and backed it up). A glitch on my PC
> >meant
[quoted text clipped - 34 lines]
>
> http://www.pksolutions.com
Alan - 12 May 2008 07:31 GMT
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
> 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
[quoted text clipped - 5 lines]
>
> Thanks.
Tony Toews [MVP] - 14 May 2008 02:58 GMT
>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

Signature
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/