By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,466 Members | 1,309 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,466 IT Pros & Developers. It's quick & easy.

JRO and Access - what program.suite is needed?

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.