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.Regio n = 'CA' "
It throws an error:
"Invalid expression in the ReplicaFilter property".
The replica db, does contain "Customers" table, which has "Region" field.
Thank you for you help.
The code, looks like:
Expand|Select|Wrap|Line Numbers
- 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 like 'CA' "
Roy