August 29, 2008 09:10pm pdt

1. angelIII 57,177
2. harfang 31,630
3. capricorn1 31,160
4. Dhaest 24,893
5. LSMCons... 24,156
6. RobSamp... 20,800
7. DatabaseMX 19,100
8. jpaulino 18,850
9. peter57r 18,229
10. jimhorn 16,378
11. ee_rlee 15,865
12. hielo 15,700
13. rorya 15,645
14. emoreau 14,500
15. frankytee 13,800
16. aiklamha 13,200
17. boag2000 13,000
18. Arthur_... 12,800
19. danaseaman 11,250
20. MikeToole 11,000
21. mlmcc 10,752
22. zorvek 10,100
23. bigjokey 10,000
24. TimCottee 9,904
25. saurabh726 9,900

1. leonstryker 659,903
2. angelIII 302,343
3. emoreau 297,108
4. acperkins 259,084
5. Dhaest 191,207
6. TimCottee 160,377
7. Arthur_... 143,121
8. MYLim 135,434
9. Sethi 112,456
10. Dabas 109,981
11. mdougan 98,310
12. ryancys 97,083
13. leclairm 93,623
14. jimhorn 90,832
15. mlmcc 86,143
16. aikimark 82,404
17. LSMCons... 76,668
18. capricorn1 75,738
19. rockiroads 70,782
20. harfang 64,790
21. spongie 60,226
22. jkaios 45,350
23. Michael_D 42,670
24. CarlWarner 41,949
25. appari 39,853

07.23.2008 at 04:01AM PDT, ID: 23587987 | Points: 500

	[x] Attachment Details

MS ACCESS DATABASE REPLICATION BETWEEN COMPANY SERVER AND SECURE WEB SITE

Asked by henrymarriott in Microsoft Access Database, VB Database Programming

Tags: Visual Basic 6 and ASP, Invalid HTTP address

Does anyone have any experience of using JRO to replicate data between Access databases where one is on the internet on a secure site. The scenario is simply one design master sitting on the company server and a replica sitting on the secure server. The design master is updated locally. The replica on the net is updated from time to time via an ASP application. The objective is simply to perform a two way sync at 3am each night. If possible we want to avoid migrating the whole thing onto SQL as the volume of data is very low but it is important that the two files are kept synchronised at least once in 24 hours. Everything syncs perfectly locally.

My main problem is that it keeps throwing up Invalid HTTP address whenever it tries to sync. Currently the db is in Access 2003 format. Any advantages of using 2000 or 2007?

Any help appreciated

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:

           
           
             The code is taken straight from MS samples thus:
 
Sub InternetSync(strLocalReplicaPath As String, _
                 strServerReplicaURL As String)
   Dim repLocalReplica  As New JRO.Replica
 
   repLocalReplica.ActiveConnection = strLocalReplicaPath
 
   ' Synchronize the local replica with the replica on
   ' the Internet server.
   repLocalReplica.Synchronize strServerReplicaURL, jrSyncTypeImpExp, _
      jrSyncModeInternet
 
   Set repLocalReplica = Nothing
   'InternetSync "c:\Data\OrderEntry.mdb", "www.mycompany.myserver.com/files/Orders.mdb"
End Sub
 
AND IS INVOKED BY
 
InternetSync "C:\Documents and Settings\Henry\My Documents\My Web Sites\BPTrial\BPdb\Localdb.mdb", https://securesite/BPdb/remotedb.mdb

           
         

Keywords: MS ACCESS DATABASE REPLICATION…

	Title
1	Replication Issue
2	Convert MDB replication to MSSQL
3	DFS Replication question.
4	Reinitialize MYSQL 5.0 Replication
5	Problems with Win2K3 DC replication …
6	AD 2003 inter-site replication

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628