Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2008

Tip: Looking for answers? Try searching our database.

Corrupt file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robbie G - 25 Aug 2007 10:00 GMT
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/


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.