Compact and repair on a design master database

C

Chris

A record in one of the tables in our database has become corrupted, I can't
remove it. When I tried compact and repair on a copy of the database it
fixed the issue but also made all of the tables etc none replicable, I could
not then make them replicable again. Was this because it was a replication
copy?
The design master has never been compacted (I only took it over 6 months
ago, been running for about 2 years it stands at 180mb), I am concerned that
if I run compact and repair on it that it will lose the ability to replicate
and I won't be able to redo it. Can anyone offer any help here please? I
don't want to have to rebuild the table do to relationships with other tables.
 
J

Jeff Boyce

Chris

Seems like a "replication" question. Have you posted in the replication
newsgroup? You might find more folks there with the experience you're
looking for...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Chris said:
A record in one of the tables in our database has become corrupted, I can't
remove it. When I tried compact and repair on a copy of the database it
fixed the issue but also made all of the tables etc none replicable, I could
not then make them replicable again. Was this because it was a replication
copy?
The design master has never been compacted (I only took it over 6 months
ago, been running for about 2 years it stands at 180mb), I am concerned that
if I run compact and repair on it that it will lose the ability to replicate
and I won't be able to redo it. Can anyone offer any help here please? I
don't want to have to rebuild the table do to relationships with other
tables.
 
D

David W. Fenton

A record in one of the tables in our database has become
corrupted, I can't remove it. When I tried compact and repair on
a copy of the database it fixed the issue but also made all of the
tables etc none replicable, I could not then make them replicable
again. Was this because it was a replication copy?

Replicated databases are very fragile, unfortunately. They can lose
replicability in a compact.
The design master has never been compacted (I only took it over 6
months ago, been running for about 2 years it stands at 180mb), I
am concerned that if I run compact and repair on it that it will
lose the ability to replicate and I won't be able to redo it. Can
anyone offer any help here please? I don't want to have to
rebuild the table do to relationships with other tables.

Make a replica of the DM first before compacting it. Or just make a
copy in the file system and if it loses replicability, kill the real
one and rename the copy to the same name.

Solving the issue is somewhat more complex. You need to find the
problematic record and delete it *before* you compact.
 
D

David W. Fenton

Seems like a "replication" question. Have you posted in the
replication newsgroup? You might find more folks there with the
experience you're looking for...

The replication newsgroup is about 1/2 my posts (since Michael
Kaplan bowed out of replication) and I monitor all the Microsoft
Access newsgroups for replication questions, so I do answer them in
place when they come up.

I've noticed an uptick in replication questions in the last month or
so. Sad, given that Microsoft is basically killing the technology in
A2K7 (the new ACCDB format does not support replication).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top