Solved

How do I recover from a corrupted replica

Posted on 2010-08-28
5
345 Views
Last Modified: 2012-05-10
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
Comment
Question by:BHelfmn
  • 2
  • 2
5 Comments
 
LVL 10

Expert Comment

by:t_hungate
ID: 33550701
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
 

Author Comment

by:BHelfmn
ID: 33551049
When I import the definition only, the resulting table is still not replicable.
0
 
LVL 10

Expert Comment

by:t_hungate
ID: 33551238
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
 
LVL 1

Accepted Solution

by:
mgoodspeed earned 500 total points
ID: 33552549
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
 

Author Closing Comment

by:BHelfmn
ID: 33761097
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now