Error Recovering Access 2003 db from Access 2007

[Richard A. Deter II]

I have a 2003 access db that became corrupted. Generally, opening this db
prompts a repair wizard which recovers the db. However, Access 2007 finds
the db unrecoverable but, on a system with Access 2003, the db is recovered
fine. I was just wondering if this was a known issue or if there was a way
around it so that I would not have to keep 2003 available for whenever this
issue may arise in the future.

 

['69 Camaro]

Hi, Richard.

I was just wondering if this was a known issue or if there was a way
around it so that I would not have to keep 2003 available for whenever
this
issue may arise in the future.

There's no way around it. Corrupted databases are sometimes recoverable in
another version of Access when it fails to repair in a certain version.
This is not guaranteed, so keeping an older version of Access only for this
purpose may not be as helpful as it seems. The best policy is to avoid
practices that tend to corrupt databases, such as sharing a database file
across the network, and to keep recent backups to restore from whenever the
database is corrupted or the developer commits an "Oops!"

However, I'd recommend keeping the Access 2003 version for a while longer so
that you can easily create Access 2003 MDE's for other computers that don't
have Access 2007 installed. It's going to be quite some time before Office
2007 is widespread throughout the workplace.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Norman Yuan]

What is the format of said database (*.mdb) file being saved? A *.mdb file
created by Access2003 could be Access2000 format (default), Access2002-2003
format, and Access97 format.

If the MDB file is not in Access97 format, I do not think you can open it in
Access97, nor you can recover it with Access97, if it is corrupted. You need
to use Access2003 (if the file is in Access2002-2003 format) or Access2000
(if the file is in Access2000 format) to convert the file format into
Access97 format.

 

['69 Camaro]

Hi, Norman.

If the MDB file is not in Access97 format, I do not think you can open it
in Access97, nor you can recover it with Access97, if it is corrupted.

Richard didn't say he was trying to open or recover the file with Access 97.
I doubt he has Access 97 installed on his workstation.

You need to use Access2003 (if the file is in Access2002-2003 format) or
Access2000 (if the file is in Access2000 format) to convert the file
format into Access97 format.

Richard doesn't need to convert the file into Access 97 format. He would
lose all of the Jet 4.0, DAO 3.6, ADO, VBA 6.X, and many important Access
Object capabilities.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Richard A. Deter II]

Thanks

Hi, Richard.


There's no way around it. Corrupted databases are sometimes recoverable in
another version of Access when it fails to repair in a certain version.
This is not guaranteed, so keeping an older version of Access only for this
purpose may not be as helpful as it seems. The best policy is to avoid
practices that tend to corrupt databases, such as sharing a database file
across the network, and to keep recent backups to restore from whenever the
database is corrupted or the developer commits an "Oops!"

However, I'd recommend keeping the Access 2003 version for a while longer so
that you can easily create Access 2003 MDE's for other computers that don't
have Access 2007 installed. It's going to be quite some time before Office
2007 is widespread throughout the workplace.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

You're welcome, Richard. I hope you don't have too many problems with
Access 2007 as an "early adopter." (It's not been released to the retail
public as yet. Amazon.com ships Office 2007 starting Tuesday of next week.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[David W. Fenton]

However, I'd recommend keeping the Access 2003 version for a while
longer so that you can easily create Access 2003 MDE's for other
computers that don't have Access 2007 installed. It's going to be
quite some time before Office 2007 is widespread throughout the
workplace.

I don't have any apps in any format beyond A2K.

 

[Tony Toews]

I have a 2003 access db that became corrupted. Generally, opening this db
prompts a repair wizard which recovers the db.

This sounds like this is a recurring problem. For more information on
corruption including possible causes, determining the offending PC,
retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access
Corruption FAQ at http://www.granite.ab.ca/access/corruptmdbs.htm

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

 

['69 Camaro]

Hi, David.

I don't have any apps in any format beyond A2K.

Nearly all of mine are Access 2000, too, for backwards compatibility, and
they're distributed as MDE's. If Richard is going to only keep Access 2007,
his MDE's are going to be incompatible with most other current installations
of Access for quite a while, so having one computer available with Access
2003 installed may make a difference (although not a big difference) when
distributing his MDE database applications. (Actually, I'm assuming that
Access 2007 calls them MDE's, not ACCDE's, but in either case, earlier
versions won't be able to read these database formats.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.