Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / October 2005

Tip: Looking for answers? Try searching our database.

Replication error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter82 - 30 Sep 2005 19:36 GMT
I have a replica master with 10 replicas. Daily, I synchronize and i
work very well during the last year. But since the beginning of th
week, there is a replica who doesn't want to do the replication : ther
is a windows error and Microsoft invite me to send this error. I'ts th
only one with this problem ! How i can do to resolve this ?

Thank you

--
Peter8
David W. Fenton - 01 Oct 2005 19:46 GMT
> I have a replica master with 10 replicas. Daily, I synchronize and
> it work very well during the last year. But since the beginning of
> the week, there is a replica who doesn't want to do the
> replication : there is a windows error and Microsoft invite me to
> send this error. I'ts the only one with this problem ! How i can
> do to resolve this ?

Does the error happen when you try to synch, or does Access crash as
soon as you attempt to open the database?

The replica is probably corrupted and needs to be repaired. If you
can open it but not synch, then you should make a copy of it and
then try to compact and repair the original.

You should also try creating a new replica from it in code, since
the problem that causes Access to crash may be one that does not
actually involve Jet.

You could also try synching with the problem replica from another
replica, for the same reason.

If the replica won't open in Access and all efforts to communicate
with it without having it open also fail, then you probably need to
have the MDB file repaired by someone like Peter Miller
(http://pksolutions.com). The replica might lose replicability in
the process of recovery, but at least you'd be able to get the data
out of it.

Otherwise, you should look through the information in Tony Toews's
corruption page:

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

None of that specifically applies to replication, but when a
replicated MDB is corrupt, the advice there still applies. I've
found, however, that even the slightest corruption in a replica
usually leads to the loss of replicability, even when 100% of the
data is recoverable. That means manually recovering the data out of
the repaired MDB and applying it to a live replica. It's a lot of
work, but better than entirely losing the data.

Signature

David W. Fenton                        http://www.bway.net/~dfenton
dfenton at bway dot net                http://www.bway.net/~dfassoc

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.