• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

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.

0
BHelfmn
Asked:
BHelfmn
  • 2
  • 2
1 Solution
 
t_hungateCommented:
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
 
t_hungateCommented:
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
 
mgoodspeedCommented:
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
 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now