Hello everyone.
Your help is very much appreciated.
I am using MS ACCESS 2003.
I am trying to create partial replica from the design master.
it all goes well until I try to set the filter using:
repPartial.Filt ers.Append "Customers",jrF ilterTypeTable, "Customers.Regi on = 'CA' "
It throws an error:
"Invalid expression in the ReplicaFilter property".
The replica db, does contain "Customers" table, which has "Region" field.
The code, looks like: -
dim repFull as new JRO.Replica
-
repFull.ActiveConnection = "C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\northwind.mdb"
-
Call repFull.CreateReplica("C:\MY_REPLICA.mdb", "description", jrRepTypePartial)
-
-
Set repFull = Nothing
-
' open the partial replica in exclusive mode and apply filters
-
repPartial.ActiveConnection = "Data Source=C:\MY_REPLICA.mdb; Mode=Share Exclusive"
-
repPartial.Filters.Append "Customers", jrFilterTypeTable, "Customers.Region = 'CA' "
-
-
Thank you for you help.
Cheers
Roy
3 2427 ADezii 8,834
Recognized Expert Expert
Hello everyone.
Your help is very much appreciated.
I am using MS ACCESS 2003.
I am trying to create partial replica from the design master.
it all goes well until I try to set the filter using:
repPartial.Filt ers.Append "Customers",jrF ilterTypeTable, "Customers.Regi on = 'CA' "
It throws an error:
"Invalid expression in the ReplicaFilter property".
The replica db, does contain "Customers" table, which has "Region" field.
The code, looks like: -
dim repFull as new JRO.Replica
-
repFull.ActiveConnection = "C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\northwind.mdb"
-
Call repFull.CreateReplica("C:\MY_REPLICA.mdb", "description", jrRepTypePartial)
-
-
Set repFull = Nothing
-
' open the partial replica in exclusive mode and apply filters
-
repPartial.ActiveConnection = "Data Source=C:\MY_REPLICA.mdb; Mode=Share Exclusive"
-
repPartial.Filters.Append "Customers", jrFilterTypeTable, "Customers.Region = 'CA' "
-
-
Thank you for you help.
Cheers
Roy
Are you missing the following Declaration? - Dim repPartial as New JRO.Replica
If Data Source and Mode are Named Arguments, wouldn't the syntax be: - repPartial.ActiveConnection = "Data Source:=C:\MY_REPLICA.mdb; Mode:=Share Exclusive"
Are you missing the following Declaration? - Dim repPartial as New JRO.Replica
If Data Source and Mode are Named Arguments, wouldn't the syntax be: - repPartial.ActiveConnection = "Data Source:=C:\MY_REPLICA.mdb; Mode:=Share Exclusive"
Thank you Adezii.
I'll try it and see what comes up.
ADezii 8,834
Recognized Expert Expert
Thank you Adezii.
I'll try it and see what comes up.
You're welcome - hope it works for you.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Bing Wu |
last post by:
Hi,
Has anyone got problem with this on large table. It seems it take ages to return the result ( half an hour :-( ).
SELECT COUNT(*) FROM COORDINATE
A strange thing is the tempory space (System Managed) keeps growing during the query:
14346747904 Dec 2 16:22 SQL00002.TDA
|
by: John Sims |
last post by:
Hello All,
Anybody out there know what this error is...I'm getting it while
trying to create a partial replica from a full replica made from the
design master.
"The Partial Replica Wizard has encountered an error while trying to
populate your partial replica with data. The error that the Jet
Engine has returned is: Reserved error (-1613); there is no message
for this error. After resolving this error, you can run the Wizard
|
by: Ondine |
last post by:
Hi
I have a client running an Access 2000 database on a small network
with 3 pc's. Two of the laptop pcs have a data replica, which they
use when not connected to the network, the 'server' being the 3rd
machine.
The other day they reported that 'suddenly' a whole load of data that
they had entered (on to the 'server' main data) that day had
'disappeared'. Not only had the new data gone, but updates performed
|
by: Jeff Smith |
last post by:
Hi
Is there a way to do partial replication of data?
I'm looking at having a central back end data file which contains all the
data from all users. But when each user synchronises the mobile data files
with the main data file, I only want data which is relevant to that user to
be synchronised to their data file.
Example:
|
by: stupi |
last post by:
I have an access database replicated over a network. Recently and more
often, after I fill one record into the database, and then try to
replicate it, I get this message "scaling of decimal values resulted in
data truncation".
I think there is nothing wrong with my database, because the same
record, introduced on another computer gives me no errors. And after
replacing the faulty replica on that computer, everything works fine.
(for a...
| |
by: Ddraig |
last post by:
Howdy,
I've spent a good 2 or 3 hours this morning trying to figure out this
code. I'm new to the .Net environment and have some VB6 skills but
that was 3 years ago.
My project I'm working on accesses a Access DB to pull in data. I used
the designer to pull in the components I needed to connect to the
database.
|
by: Shiva |
last post by:
Hi,
In my partial replica only the contents of a few tables is being updated /
synchronized when I synchronize it with another replica. Is it possible to
find out which tables are synchronized? I took a look at the properties of
the table, but to no avail.
Thanks a lot.
|
by: roypython |
last post by:
Hello everyone.
Your help is very much appreciated.
I am trying to create partial replica from the design master.
it all goes well until I try to set the filter using:
repPartial.Filters.Append "Customers",jrFilterTypeTable,"Customers.Region = 'CA' "
It throws an error:
"Invalid expression in the ReplicaFilter property".
The replica db, does contain "Customers" table, which has "Region" field.
|
by: MRileyDE |
last post by:
I am working on an replica Access database with VB Coding that is used by multiple computers. On some computers, when one opens the database - a db1.mdb will appear as if it's copying itself. For other computers, this doesn't occur. All are using Windows XP and Windows Access 2003. The more one opens the database from some computer the more the db#.mdb appear -- yet all the data is still being stores and received by the Replica/Design Master....
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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,...
|
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...
|
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...
|
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();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |