db.synchronize progress bar?

[ASherbuck]

I've made progress bars in the past and I've sync'd replicas in the past. But something that's always been a problem for me is meshing the two together.

With Access 2007 is it possible to create a progress bar for use during:

Dim db As DAO.Database

   On Error GoTo CmdSynchronize_Click_Error

Set db = CurrentDb

db.Synchronize (Replica)
DoEvents
db.Close
MsgBox "Synchronization Complete"
Quit
   On Error GoTo 0
   Exit Sub

CmdSynchronize_Click_Error:

    Call ErrorHandler(Err.Number, Err.Description, "CmdSynchronize_Click")
    Exit Sub

I'm unable to find anything already in Access to show what % of completeness exists, or even a way to know what table it is currently checking/working on.
Does a method exist for this or will it involve long hours working on something custom?

 

[dfenton]

I'm unable to find anything already in Access to show what % of completeness exists, or even a way to know what table it is currently checking/working on.
Does a method exist for this or will it involve long hours working on something custom?

There is no such event, because Access/Jet cannot know how much is yet to happen.

If you use the TSI Synchronizer, you can get certain kinds of information, but none of it is going to translate into the kind of percentages you can pass to the SysCmd progress bar.

For my synchronization UI's, I simply have a progress bar that goes back and forth, so the user can tell it's working, while I poll the TSI Synchronizer to see if it's done. One could also poll the MSysExchangeHistory table, but there you'd need to be careful to make sure you're querying the right row. That's why I use the TSI Synchronizer, since I can be absolutely certain that the information I'm using applies to the particular synch operation I'm interested in.

 

[ASherbuck]

dfenton thank you for your reply. I was actually hoping to get a response from you on this as I've had to reference posts of yours and your wiki on the subject through this process. Thanks for taking the time.