473,699 Members | 2,738 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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
4 3330
gs*****@gmail.c om wrote in message
<11************ **********@g43g 2000cwa.googleg roups.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************ **********@g44g 2000cwa.googleg roups.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
1542
by: Hans-Joachim Widmaier | last post by:
Recently, there was mentioned how someone who had understood Python's error handling would write the "open and read file with error handling" idiom. If I remember correctly, it went like this: try: f = file(filename, op) except IOError, e: # Handle exception else: # Use the file
1
1355
by: donis | last post by:
Hi i am doing a project for making a hotel management system in Microsoft Access I wantto make a hotel with 20 rooms 5 = suite 5= double 5= duobleo view 5 - rooms at single 4 types of room with 4 different prices
11
17053
by: Rosco | last post by:
Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the Ford Fairlane. I need this info to complete a school project. Thanks.
20
3334
by: Olav.NET | last post by:
I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to speed. I like books with practical exercises, and also with test questions (like cert books) *2*
47
4527
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
233
8360
by: E. Robert Tisdale | last post by:
I have access to a wide variety of different platforms here at JPL and they all have pretty good C 99 compilers. Some people claim that they have not moved to the new standard because of the lack of C 99 compliant compilers. Is this just a lame excuse for back-sliding?
17
2524
by: CBFalconer | last post by:
David Brown wrote: .... snip ... The problem with the gcc test suite is that it is geared to the gcc 'standard', rather than the ISO standard. A test suite should be open-source, and there should probably be several of them (with some commonality), one each for C90, C99, and C0X. The tests should be clearly tied to the standard. There are several classes of tests needed, i.e. conformance, detection of errors, and quality. The last...
9
4757
by: Paul H | last post by:
As I understand it, to distribute a runtime version of Access 2003 with my app I need to spend £600 on "Visual Studio Tools for Office System package" which contains the RT plus a load of stuff I do not want. Or.... I can supply the client with a copy of "AccessRT.msi" which is on my Office 2003 pro CD and not tell anyone! Who is being more unscrupulous, me or Microsoft? Surely Microsoft forcing me
21
4095
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a reliable way of connecting Access to a server. I am willing to switch to any version of Access which might solve the problem. Which server would you recommend and what are the advanatages and disadvantatges of the server you propose? Please also inlcude...
0
8685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9171
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8905
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8880
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7743
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5869
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3053
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2342
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2008
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.