473,396 Members | 2,009 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

.bak and .mdb file - corruption

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

Jun 29 '06 #1
4 4210
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:11**********************@b68g2000cwa.googlegr oups.com,
pa**@softsmart.co.uk 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

Jun 30 '06 #2
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:11**********************@b68g2000cwa.googlegr oups.com,
pa**@softsmart.co.uk 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


Jun 30 '06 #3
pa**@softsmart.co.uk wrote in
news:11*********************@b68g2000cwa.googlegro ups.com:
It looks like this might be a lost cause - restore from back up
and try to re-enter all the missing data!!


Or send it to Peter Miller at PKSolutions.com and he'll tell you if
he can recover it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 30 '06 #4
And further to David's suggestion to try Peter Miller at PK
there is also www.EverythingAccess.com . Pete's been around
for ages <g> but EverythingAccess I've only just found.

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

In
news:11*********************@b68g2000cwa.googlegro ups.com,
pa**@softsmart.co.uk typed:
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:11**********************@b68g2000cwa.googlegr oups.com,
pa**@softsmart.co.uk 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

Jul 1 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jeremy Jones | last post by:
I've written a piece of code that iterates through a list of items and determines the filename to write some piece of data to based on something in the item itself. Here is a small example piece...
1
by: Mike Thomas | last post by:
I have been working for several years on an Access application (front end mdb) which is now about 15 meg. The data is in a different mdb and the tables are linked to the front end mdb. In the...
2
by: nepdae | last post by:
Please forgive me, this is a long one. My 11-user Access 2000 database is having recurring corruption problems. The symptoms include the following: 1) corrupted fields in recently created or...
15
by: Amir Michail | last post by:
Hi, Trying to open a file for writing that is already open for writing should result in an exception. It's all too easy to accidentally open a shelve for writing twice and this can lead to...
5
by: djhexx | last post by:
Hello. I have an ASP.NET application (C#) that I allow users to upload files. Files get stored in a SQL2005 database. The file data is stored in a varbinary(max) column. When the user uploads...
0
by: =?Utf-8?B?T3JsYW5kbw==?= | last post by:
Hi, I'm troubleshooting an issue in the field where a simple text file that gets read/written over and over again ends up zeroed out somehow (ie it should have XML, but when looked at in a...
16
by: Wayne | last post by:
I have an Access 2003 data file that has now corrupted twice in a week. The database is extremely simple with one main data table and a few lookup tables. The lookup tables are linked to the main...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.