i have the backend of my database currently (where my data is) stored on my machine under (c:\database\data.mdb), and the front end on my desktop. instead of the back end being stored on my local machine, i want to move it to and from my ftp site. why you ask.... because when i open the front end of my database (stored on my desktop) i want it to retreive the backend database file "Data.mdb" from the ftp site and put it in the directory "c:\database\". then when i exit the database i want it to move (not copy) the file "data.mdb" back to the ftp site.
all i need is a little help with the code....
i am new to VB. but have written procedures in access for copying files from one location to another, but dont now how to move file to and from an ftp site.
I feel you will have a lot of problems with data Integrity but here is the code to do it this code is to download it. Just change for uploading
on open code
Open FilePath & "GetFile.txt" For Output As #1 ' Create a script to get the Netwash file to the current directory
Print #1, "ftpIPAddress"
Print #1, "Username"
Print #1, "Password"
Print #1, "cd dirname"
Print #1, "cd additional Dirnames only if needed"
Print #1, "get filename ""full path and file name to save EX C:\mydb.mdb"""
Print #1, "quit"