JRO and Access - what program.suite is needed?

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

re: JRO and Access - what program.suite is needed?

gstaats@gmail.com wrote in message
<1140024874.181580.283590@g43g2000cwa.googlegroups .com> :[color=blue]
> 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[/color]

Try setting a reference to Microsoft Jet and Replication Objects 2.#
Library.

Are you sure you need implicit instantiation? Why not

dim repMaster as jro.replica
set repMaster = new jro.replica

--
Roy-Vidar

re: JRO and Access - what program.suite is needed?

How do I go about doing that? I'm new to VBA programming, but not to
programing. I've done a lot of work with embeded systems in assembly,
and C++... Sorry if the question sounds kind of dumb

re: JRO and Access - what program.suite is needed?

Staats wrote in message
<1140032609.093373.242730@g44g2000cwa.googlegroups .com> :[color=blue]
> How do I go about doing that? I'm new to VBA programming, but not to
> programing. I've done a lot of work with embeded systems in assembly,
> and C++... Sorry if the question sounds kind of dumb[/color]

Find References on the Tools menu (in VBE;))

--
Roy-Vidar

re: JRO and Access - what program.suite is needed?

Awesome! Thanks for the help! I'm new to the .net environment... I was
hoping that I would be able to do this without having to try to get
additional software. Its like pulling teeth to get the IT department to
install anything on here...