JulianBaker
asked on
FTP using docmd.transferdatabase
I wish to transfer information from an office based MS Access database to/from a database located on an externally hosted web server to which I only have FTP access.
I think I can probably use the Microsoft Internet transfer control (msinet.ocx) to do the transfer via FTP but would prefer to keep things as simple as possible.
What I would like to know is if it is possible to use the DOCMD.TRANSFERDATABASE command to transfer information via FTP and if so what is the syntax for specifying the remote database in the command?
I think I can probably use the Microsoft Internet transfer control (msinet.ocx) to do the transfer via FTP but would prefer to keep things as simple as possible.
What I would like to know is if it is possible to use the DOCMD.TRANSFERDATABASE command to transfer information via FTP and if so what is the syntax for specifying the remote database in the command?
ITC is about your only solution...but your ftp idea isn't likely to work if you are trying to update the db...
what i use to update my web db is something like this
access form fills variables in an ITC url string or form variable
the url is a coldfusion page (but could be asp, php or whatever) which triggers a db insert or update and passes back the result of the insert to ITC for user feedback
i suppose what you could try is to ftp the data to a dir and then trigger something to import the data via some server sided scripting...
what i use to update my web db is something like this
access form fills variables in an ITC url string or form variable
the url is a coldfusion page (but could be asp, php or whatever) which triggers a db insert or update and passes back the result of the insert to ITC for user feedback
i suppose what you could try is to ftp the data to a dir and then trigger something to import the data via some server sided scripting...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I would imaging exporting table as csv, ftp it across them import into new table
u can find examples on using WinInet here
http://www.mvps.org/access/modules/mdl0037.htm