Hi, I have a stand alone VB ap

[JennB]

Hi,

I have a stand alone VB application that runs off of an Access database. My client would like to take the inventory from this database and make it available online. What VB code could I use to FTP the database to the host? The client is not technical so I would like to have them simply push a button to upload the information. Also, is it possible only to upload certain tables from the database. The information saved in other tables is confidential and we would prefer to keep it secure on their server.

Thanks for your help.

jenn

 

[haysie]

Ther Windows API has a pretty simple 'FtpPutFile' function that should do the job quite nicely. This function needs to be used in conjunction with the InternetConnect function.

If you only want to upload selected tables one approach would be to use the 'CopyObject' method of the Access DoCmd object to copy the selected tables to a second database and upload that instead.