Avatar billede fbdk Nybegynder
12. april 2004 - 12:00 Der er 6 kommentarer og
1 løsning

Synkronisering af Access med FTP

Sidder og bokser lidt med at få Access 2002 til at syncronisere med et replika via FTP. Jeg når så langt gennem processen, at jeg gennem dialogboksene får logget ind på FTP serveren, valgt mappe og fil. Access lukker så masterkopien ned og klargør til syncronisering, men stopper så med en "HTTP" fejl !! - er der nogen der kan hjælpe mig lidt på vej ??
12. april 2004 - 13:37 #1
kan man overhovedet synkronisere via FTP? Du kan jo ikke sammenkæde tabeller via internettet. Men jeg ved faktisk ikke om replikeringen kan finde ud af det?
Avatar billede daniel_d Nybegynder
09. februar 2005 - 22:19 #2
Fandt du ud af hvordan... sidder med samme problem nu - vil gerne syncronisere med en db på nettet...
Avatar billede fbdk Nybegynder
09. februar 2005 - 23:43 #3
Nej, er stadig nødt til at kopiere hele db istedet for sync. - desværre!
Avatar billede terry Ekspert
10. februar 2005 - 08:55 #4
Without knowing very much at all about replication, I think it will be necessary to have replication software installed on the local and remote(web) PC's.

This is taken from http://support.microsoft.com/kb/q182886/

17.    What is indirect synchronization and how do I make it work?
Indirect synchronization requires use of Replication Manager.  When you synchronize two replicas using indirect synchronization, a synchronizer on one computer exchanges changes with a synchronizer on another computer, thus avoiding the direct opening of a database over a wide area network (WAN).
There are several benefits of using this process:
•    It greatly reduces the possibility of database corruption that could be caused by a line drop during a database update.
•    Should an indirect synchronization fail, Replication Manager will simply re-send any changes on the next pass.
Replication Manager is included with the Office 97 Developers Edition. For Microsoft Access 95, it is packaged with the Microsoft Access Developers Toolkit (ADT). You will need to configure the Replication Manager at both the local and remote sites and create separate dropbox locations for each Replication Manager to use indirect synchronization.
This involves setting up the dropboxes (or shared folders), which will be used to store the changes. You don’t want to actually locate the replicas themselves in the shared folders or else indirect synchronization will be bypassed in favor of a direct synchronization.
Here are the steps to configure Replication Manager on the local computer:
1.    Install ODE with Replication Manager (or use Office Developers Edition Setup wizard).
2.    Create a shared folder, which will be the Synchronizer dropbox. (Do not put the replica in ANY shared folder, or else indirect syncs will be bypassed).
3.    Configure Replication Manager for indirect synchronization by checking the option to support indirect synchronization. Follow the rest of the steps in the wizard by specifying the shared folder you created as the dropbox, by naming the Synchronizer, and by selecting a synchronizer log file.
4.    Open Replication Manager and select the replica to be managed.
5.    Optionally set up a synchronization schedule.
          On the remote computer:
6.    Install Replication Manager and create a share for the Synchronizer drop box, as in steps 1 and 2 above.
7.    Copy the replica from the local to the remote computer (using a regular file copy), and place it in an unshared folder. If the replica is in a shared folder, or the subdirectory of a shared folder (this includes the root), indirect syncs will be bypassed and a direct exchange will occur.
8.    Open the newly copied replica in the unshared folder on the client computer in Replication Manager, and elect to manage the replica.
9.    Connect back to the local computer and synchronize, in order to let the local computer know about the location of the copy on the remote computer.
Whenever the Replication Manager manages a replica, it will write the location of its dropbox into the replica. With remote connections, you must now notify other replicas of the dropbox location, which is why you need to do step 4 above. You notify other replicas of the new address, or dropbox, in one of two ways: either you create a new replica from this managed replica, or you synchronize with an existing replica.
Avatar billede terry Ekspert
10. februar 2005 - 08:56 #5
Avatar billede terry Ekspert
10. februar 2005 - 09:05 #6
If you are using Access 2000 then try changing to 2002.

There is some interesting reading here
http://www.tech-archive.net/Archive/Access/microsoft.public.access.replication/2004-10/
Avatar billede fbdk Nybegynder
03. november 2012 - 10:18 #7
Har desværre hverken selv eller med ovennævnte indlæg fået løst problemet og lukker hermed tråden
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester