replication synchronisation successful?

Posted on 2013-01-15
Medium Priority
Last Modified: 2013-01-19
hey guys,

i just tested and realised that we can't sync 2 databases at once to the main replica on the network. the 2nd database that i'm trying to sync will say that there was an error or something like that.

how can i programmatically tell that the sync was not successful and thus queue it up to sync again? thanks guys!! hrmm, i haven't tested using the method of err and on error goto 0 then looping until there is no error and exit sub, but if yall have better ways of testing if it were successful let me know ya! thanks guys!!g
Question by:developingprogrammer
LVL 61

Accepted Solution

mbizup earned 2000 total points
ID: 38782051
If you are getting an actual error message and number, I would suggest standard error handling techniques as you described.

Another thing you can try is creating a table for synchronization history.  Write details such as user, date/time, Replica Name or ID, ETC to the history table immediately before sychronizing.   Such a table can be used to determine if syncronization was successful, and it can also let you/the user know the time of the last synchronization, and any other info you chose to store.

 If the synchroniztion was successful, you will have a matching record in the history table in your Master Design copy of the database.

You can query the Master Design copy like this:

SELECT tblSynchronizationHistory.*
FROM tblSynchronizationHistory IN "YourPath\YourMasterDatabase.mdb";

Open in new window

You can also use a "unmatched query" that Joins the history table in your replica with the history table in your Master Copy to determine if there are any unmatched records:

SELECT rep.*
FROM tblSynchronizationHistory rep 
LEFT JOIN tblSynchronizationHistory  IN "YourPath\YourMasterDatabase.mdb" m
ON rep.ID = m.ID;

Open in new window

If there are any records in the results immediately after a synchronization attempt, that indicates that the data is not the same and the synchronization was not successful.

I personally haven't used this method (again I've never had a need to replicate/synchronize databases), but it is something I would try myself with that setup.
LVL 59
ID: 38782503
<<i just tested and realised that we can't sync 2 databases at once to the main replica on the network. the 2nd database that i'm trying to sync will say that there was an error or something like that. >>

 Are you doing the synch in code or through replication manager?


Author Comment

ID: 38796404
thanks jim, i was doing it through replication manager but now i'm doing it in code. mbizup gave me this code to check if we could find the design master (1st check) and then later i did a resume on error and and error would give a non-zero err object so i checked for non-zero err object (2nd check).

mbizup, thanks for your codes and suggestions / guidance! always fantastic advice as usual!! = ))

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

627 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