Access 2002 vs Access 2003

[SueM]

I have created a database in Access 2002. It is being run on the desktop. I
have a user that is using the database and is running Access 2003. When she
opens the data base, she gets the following error message and corrupts the
entire database. I can no longer get into the database either. Here is the
message:

Microsoft Access has detected corruption in this file. To try to repair the
corruption, first make a backup copy of the file. Then, on the Tools menu,
point to Database Utilities and click Compact and Repair Database. If you
are currently trying to repair this corruption then you will need to recreate
this file or restore it from a previous backup.

I am unable to Compact and Repair the database. Each time, the error message
comes back up. I am able to go to Office Links and 'dump' my tables to .xls
files and create a new database and import the data, but I loose all of my
queries, forms, VB code and macros.

HELP!!

 

[John W. Vinson]

I have created a database in Access 2002. It is being run on the desktop. I
have a user that is using the database and is running Access 2003. When she
opens the data base, she gets the following error message and corrupts the
entire database. I can no longer get into the database either. Here is the
message:

Microsoft Access has detected corruption in this file. To try to repair the
corruption, first make a backup copy of the file. Then, on the Tools menu,
point to Database Utilities and click Compact and Repair Database. If you
are currently trying to repair this corruption then you will need to recreate
this file or restore it from a previous backup.

If you have A2002 available, compact and repair the database in 2002... then
open it in 2003. Do you see the same problem?

See Tony's corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

John W. Vinson [MVP]

 

[SueM via AccessMonster.com]

John,

Thanks for your reply, but, yes, I've tried to compact and repair it in a2002
and in a2003. I get the same 'corruption' message. It won't allow me to do
anything in either version. I can't open any tables, queries, forms, macros.
I thought maybe it was the person's PC that is using 2003. I had her load
all of the patches and service packs, but she continues to corrupt this
database and another one that she is using that was also created in a2002.
I've checked the settings for her Access in her options tab and everything
seems to be set correctly. I'vre run out of things to try!

I have created a database in Access 2002. It is being run on the desktop. I
have a user that is using the database and is running Access 2003. When she

[quoted text clipped - 7 lines]

are currently trying to repair this corruption then you will need to recreate
this file or restore it from a previous backup.

If you have A2002 available, compact and repair the database in 2002... then
open it in 2003. Do you see the same problem?

See Tony's corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

John W. Vinson [MVP]

 

[John W. Vinson]

John,

Thanks for your reply, but, yes, I've tried to compact and repair it in a2002
and in a2003. I get the same 'corruption' message. It won't allow me to do
anything in either version. I can't open any tables, queries, forms, macros.
I thought maybe it was the person's PC that is using 2003. I had her load
all of the patches and service packs, but she continues to corrupt this
database and another one that she is using that was also created in a2002.
I've checked the settings for her Access in her options tab and everything
seems to be set correctly. I'vre run out of things to try!

Sounds like her installation of Access might itself be damaged. Try
*completely* removing Office from her computer (search
http://support.microsoft.com for "removal tool", and use it in addition to
uninstalling); reinstall Office and see if that resolves the problem.

John W. Vinson [MVP]

 

[SueM via AccessMonster.com]

Thanks, John. We're going to try that.

John,

[quoted text clipped - 6 lines]

I've checked the settings for her Access in her options tab and everything
seems to be set correctly. I'vre run out of things to try!

Sounds like her installation of Access might itself be damaged. Try
*completely* removing Office from her computer (search
http://support.microsoft.com for "removal tool", and use it in addition to
uninstalling); reinstall Office and see if that resolves the problem.

John W. Vinson [MVP]