JRO and Access - what program.suite is needed?
JRO and Access - what program.suite is needed?
am 15.02.2006 18:34:34 von gstaats
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?
am 15.02.2006 20:28:30 von RoyVidar
gstaats@gmail.com wrote in message
<1140024874.181580.283590@g43g2000cwa.googlegroups.com> :
> 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
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?
am 15.02.2006 20:43:29 von gstaats
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?
am 15.02.2006 20:48:28 von RoyVidar
Staats wrote in message
<1140032609.093373.242730@g44g2000cwa.googlegroups.com> :
> 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
Find References on the Tools menu (in VBE;))
--
Roy-Vidar
Re: JRO and Access - what program.suite is needed?
am 15.02.2006 20:57:29 von gstaats
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...