Re: .bak and .mdb file - corruption

They are still using Access 97 and the error message appears as soon as
you try to either open or repair the database using any method I can
think of.

The file size also appears to have reduced from what is was, as far as
I can tell it is about 25% smaller than it should be.

It looks like this might be a lost cause - restore from back up and try
to re-enter all the missing data!!

Thank you for your response

Nick Coe (UK) wrote:
See if any of Allen Brownes' recovery tips work.

http://allenbrowne.com/ser-47.html

When exactly do you get the unrecognised format message -
during import of tables to new db, when opening new db after
import, when trying to open renamed .bak, ?

Also which version of Access?

This is useful for A2000 with links to other versions:
http://support.microsoft.com/kb/209137/en-us

--
Nick Coe (UK)
http://www.alphacos.co.uk/
AccHelp is now free/donateware



In
news:1151602693.460664.324140@xxxxxxxxxxxxxxxxxxxxxxxxxxxx,
paul@xxxxxxxxxxxxxxx typed:
A client appears to have either completely corrupted their
.mdb file or has somehow managed to create a .bak file
whilst
trying to zip the .mdb file.

Can anyone advise how I might be able to help them restore
the
.mdb file from what appears to be a .bak file. I have
tried
renaming the extension and repairing, both within Access
and
using a shortcut /repair. I have also tried creating a new
.mdb and importing the tables. However all I am getting is
the
"unrecognised database format" error.

Thank you

.

Relevant Pages

  • Re: Unable to Append All the Data to the Table
    ... It was the error message that was in error. ... I recommend that you first try using an built-in repair utility ("Compact ... Go to the Tools menu, select Database Utilities and then click Compact ...
    (microsoft.public.access.queries)
  • Re: Compact & Repair
    ... Each user must have his/her own copy of the mdb file; ... SQL Server 2000 database located on the same server that the .mdb file ... get everybody out, compant & repair, and then they would be ok until the ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Database Will Not Migrate or Repair - Office 2004 to 2008
    ... updates - with an Entourage database that is about 10.5 gb. ... end indicates that there is a problem accessing the data and to repair the ... database I get an error message after about 20 minutes that a problem was ...
    (microsoft.public.mac.office)
  • Re: (0x80004005) error
    ... Make sure the database itself has write permissions. ... trying to accces an mdb file from an asp page ... >> usual Microsoft cases wher the error message ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Cant open DB
    ... you get this error message your database is beyond hope of ... repair. ... >database file. ... After which I will secure them again with my ...
    (microsoft.public.access.setupconfig)