Hello,
In Sept. 2005 I changed the retention period of my access-DB (Access
2000-DB
in Office 2003) by using JRO:
------------------------------------------------------------------------------
---------------------------
In the Design Master, set a reference to "Microsoft Jet and Replication
Objects 2.x Library". Then use the following code:
Dim oReplica As JRO.Replica
Set oReplica = New JRO.Replica
oReplica.ActiveConnection = CurrentProject.Connection
oReplica.RetentionPeriod = 1000 'Days
Set oReplica = Nothing
Then synchronise all the replicas so the new value filters through the
set.
------------------------------------------------------------------------------
----------------------------
Now the 1000 Days are over ...
I tried today to change the retention period by using the JRO-method as
described above.
Now (1000 days later) It doesn't work - I got the following error
message:´
runtimeError: -2147024770 (8007007e)
method 'Connection' for the object '_CurrentProject' has failed
Has anybody an idea? What´s the problem?
Thanks Chris
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-replication/200804/1
