How do I recover from a corrupted replica

I use a 2002-2003 version of an MS Access database.  All of the current data is on a database that consists only of talbes where the replicable property is greyed out.

I am interested in exporting the data to a new database that has replicable tables without having to recreate the structure manually.

BHelfmnAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mgoodspeedConnect With a Mentor Commented:
There are commercial tools for recovering Access Databases, but if you have a copy of Access 2007, it is a champ at recovering corrupted databases.

Follow t hungate's directions
0
 
Tony HungateDirector of TrainingCommented:
Have you tried to create a new database and use the import wizard.  Select the option for structure only.  See if that will do it for you.

In Access 2010, the option is definition only, but I think in 2003 it was structure only.

TLH
0
 
BHelfmnAuthor Commented:
When I import the definition only, the resulting table is still not replicable.
0
 
Tony HungateDirector of TrainingCommented:
Would you mind posting a copy of your source db, so that I can test it on my system.  If you have the capability remove any data from the table.  I'll see if I can find a good solution for you.

TLH
0
 
BHelfmnAuthor Commented:
I ended up using manage to compact and repair the database and then was able to able to recover the design master.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.