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 / January 2008

Tip: Looking for answers? Try searching our database.

Remove item from schedule

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Don Udel (ETC) - 14 Jan 2008 16:24 GMT
We had a design master (DM7), that was being synched every morning at
12:15am.  This kept the design master from expiring, and also allowed design
changes to apply to the "hub" while activity was low.  As field users
synched their replicas, they got the new design changes.  This has worked
well for us for the last year.

Last week, we had to create a new design master (DM8) as design changes in
DM7 were no longer updating to the hub.  All went well creating the new
design master.  I now notice in our transaction log (homebuilt, reading the
Access system tables) that we are getting an automatic synch attempt every
15 minutes.  Nothing transfers because it can't find the replicata (DM7).
Replica Manager no longer shows DM7, so I can't change the schedule from
there.  On the 'hub" database, where DM7 was synching to, I can see the
schedule entry in the MSYSSchedule table.  It won't let me change or delete
the entry for DM7, to keep it from attempting to synch.

It seems to me that when I dropped DM7 from the replica set (using Replica
Manager), that it should have deleted any schedule items for the replica as
well.  It seems to have done this in the past (I have disabled synch
schedules in the Schedule table).

This probably would not be an issue if I had deleted the schedule (while it
still was visible in Replication Manager)  prior to removing the the defunct
replica.  But that time is past.  How do I remove the schedule entry or keep
the defunt replica from attempting to synch.

Thanks in advance,

Don
David W. Fenton - 14 Jan 2008 18:12 GMT
"Don Udel \(ETC\)" <donudel@ellijay.com> wrote in
news:O5ktknsVIHA.4712@TK2MSFTNGP04.phx.gbl:

> This probably would not be an issue if I had deleted the schedule
> (while it still was visible in Replication Manager)  prior to
> removing the the defunct replica.  But that time is past.  How do
> I remove the schedule entry or keep the defunt replica from
> attempting to synch.

Have you tried using the TSI Synchronizer to clear the whole
schedule and reset it?

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

Don Udel (ETC) - 14 Jan 2008 18:37 GMT
Thanks David.

I have not tried TSI.  Will TSI just drop in; or is there configuration
involved.  I'd use TSI to fix the schedule issue; but I'm reluctant to use
non supported software for a mission application.

Don
> "Don Udel \(ETC\)" <donudel@ellijay.com> wrote in
> news:O5ktknsVIHA.4712@TK2MSFTNGP04.phx.gbl:
[quoted text clipped - 7 lines]
> Have you tried using the TSI Synchronizer to clear the whole
> schedule and reset it?
David W. Fenton - 20 Jan 2008 22:26 GMT
"Don Udel \(ETC\)" <donudel@ellijay.com> wrote in
news:OmcvRytVIHA.536@TK2MSFTNGP06.phx.gbl:

> I have not tried TSI.  Will TSI just drop in; or is there
> configuration involved.  I'd use TSI to fix the schedule issue;
> but I'm reluctant to use non supported software for a mission
> application.

It's a DLL and you need to register it to use it.

It's much better software than most supported commercial software.

Signature

David W. Fenton                  http://www.dfenton.com/
usenet at dfenton dot com    http://www.dfenton.com/DFA/

Don Udel (ETC) - 23 Jan 2008 16:12 GMT
Thanks David,

Will give it a shot.

Don
> "Don Udel \(ETC\)" <donudel@ellijay.com> wrote in
> news:OmcvRytVIHA.536@TK2MSFTNGP06.phx.gbl:
[quoted text clipped - 7 lines]
>
> It's much better software than most supported commercial software.
 
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.