467,114 Members | 1,293 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,114 developers. It's quick & easy.

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

Feb 15 '06 #1
  • viewed: 3079
Share:
4 Replies
gs*****@gmail.com wrote in message
<11**********************@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
Feb 15 '06 #2
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

Feb 15 '06 #3
Staats wrote in message
<11**********************@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
Feb 15 '06 #4
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...

Feb 15 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Hans-Joachim Widmaier | last post: by
11 posts views Thread by Rosco | last post: by
233 posts views Thread by E. Robert Tisdale | last post: by
9 posts views Thread by Paul H | last post: by
21 posts views Thread by nihad.nasim@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.