Implementing Database Rep/Synch With JRO Thourgh Code

[Staats]

I know that that exact subject is on the MSDN website - I have read
through those chapters and understand how to implement JRO replication.

My question is what tools or software does one need inorder to use the
extensions and commands referenced? The Access 2002 VBA editor will not

recognize any methods of 'JRO'. The first command line of

Dim repMaster as New JRO.Replica


does not compile. Do I need Visual basic.net to use this technique? Or
do I need some developers package in order to use this? I am working on

creating a user-friendly interface to synchronize replicas. Our IT
department keeps the PC's locked down, so I can't really do much
outside of the VBA editor as far as installing new DLL's or what not...

Thanks in advance
~Garrett

 

[Brendan Reynolds]

You need a reference (Tools, References in the VBA IDE) to the Microsoft Jet
and Replication Objects 2.6 Library.