Link tables - via FTP 3

[meltingpot]

HI ...
I have an access Db that runs in my office. There is also a copy online which people update via the web. I need the online Db to update the office (Master) several times aday

What is the best way of updating the office Db with info added to the remote public Db.

I can only link via FTP...

It only needs to sync one-way (public to office)

Please advise :-0

 

[Remou]

Have you looked at replication?

 

[meltingpot]

Hi Remou ... yes I did but it was the path to the remote sever I didnt understand. The connection to the server has to be via FTP. I can not map a path to that server and using a UNC such as \\remote_server\root\data\database.mdb etc will not work as a FTP session needs to be opened

Is there any scripting to open an FTP session in Access ?

 

[Ed2020]

You could use an ftp script to copy the backend database from the remote location to a local server and then relink to the new backend.

This script may give you something to work with:

Open "c:\local data\DelScript.txt" For Output As #1 '/* file to write the ftp script */

Print #1, "ftp"
Print #1, "open servername"
Print #1, "username"
Print #1, "password"

Print #1, "lcd " & Chr$(34) & "c:\Local Data" & Chr$(34)
Print #1, "mget " & Chr(34) & filetotransfer.mdb & Chr(34)
Print #1, "y"
Print #1, "bye"
Print #1, "quit"
Close #1
CSV_File_Control_set.MoveFirst

x = Shell("C:\Windows\system32\ftp.exe -s:" & Chr$(34) & "C:\local Data\DelScript.txt" & Chr$(34), vbHide)

Ed Metcalfe

Please do not feed the trolls.....

 

[Remou]

I found this

http://www.tek-tips.com/viewthread.cfm?qid=1073963&page=1

with the Google search at the top of the page.

 

[Ed2020]

Nice find Remou, I haven't seen that solution before. Have a star.

Ed Metcalfe.

Please do not feed the trolls.....

 

[meltingpot]

Thanks Remou and ed2020 ...

I was looking for it to be automated and would sync at given periods, once an hour etc.

Im still running through the sripts - my brain hurts

 

[Ed2020]

Either of the examples given could be scripted to run from a timer event behind a hidden form....

Ed Metcalfe.

Please do not feed the trolls.....

 

[meltingpot]

Ok .... Ill try that. Thanks for the Troll tip, ive always been unsure wheather to feed or not

 

[Remou]

I have never been sure whether it was trolls specifically or all mythical beings. Perhaps we could have a FAQ, Ed2020?

 

[Remou]

PS meltingpot, if you have found Ed2020 helpful, and I think you have, please click

Thank Ed2020
for this valuable post!

Which you will find at the bottom of each post.

 

[Ed2020]

I have never been sure whether it was trolls specifically or all mythical beings. Perhaps we could have a FAQ, Ed2020?

It's only trolls. It's perfectly safe to feed the rest of them.

Ed Metcalfe.

Please do not feed the trolls.....

 

[meltingpot]

You have been both valuable and now the problems start trying to get it to work on my end - thank god ive a Troll to comfort me !