File Download

[Anthony Ching]

I have a database table that contains a list of file (by user) that users
need to download from the server to their notebook (connected through a
wireless network). I wish to automate the process so that when the user click
a button in the access application, the file can be downloaded. How can I do
this using Access Form and VBA.

Thanks.

 

[Tom van Stiphout]

On Mon, 29 Dec 2008 19:31:01 -0800, Anthony Ching

Use a recordset to loop over the records in the table.
Then use the FileCopy statement to copy each file.

-Tom.
Microsoft Access MVP

 

[Anthony Ching]

Thanks, much appreciated.
--
Anthony

On Mon, 29 Dec 2008 19:31:01 -0800, Anthony Ching

Use a recordset to loop over the records in the table.
Then use the FileCopy statement to copy each file.

-Tom.
Microsoft Access MVP