how to synchronize 2 mdb files via asp

[way2many]

Hi,
we have 2 copies of asp/Access solution on 2 different web servers. We need to synchronize MDBs (1 table) every 3-4 hours. What would be the best way of doing this using asp?

Thank you.

 

[RhythmAddict]

I'm not sure if you want/need to do this via asp. I think I would probably right a vbs script (basically the same thing as ASP except minor differences) Then you could just do a select and an insert and loop through the records...Then you could use the task manager to run this on whatever increment you'd like. You could also use the wsh.sleep method, and let the script pause for x amount of time....though i'd prob sick with the first option. Let me know if this helps.

 

[way2many]

RhythmAddict,
thank you for answering.
Would you, please, give me a bit more details on how to do it with vbs or direct to web info on this subject.

Thank you

 

[DreXor]

i believe it can be done via ODBC and db tools, but this is something that should be asked in the MS Access forum for a more definitive answer.

DreX
aKa - Robert
if all else fails, light it on fire and do the happy dance!