Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TAS
Yak Posting Veteran
65 Posts |
 Posted - 2005-09-15 : 09:25:54
|
| Is there any way to connect to FTP server from Access front end? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-09-15 : 19:22:32
|
| You can do a little VB/VBA programming: http://www.15seconds.com/issue/981203.htmYou can probably copy and paste that code into an Access module, it might need some tweaking but it should work.Or you can use the built-in Windows FTP command-line utility. You can use it in an Access macro with the RunApp action. The Windows Help file (under the Start menu) has all the details on it under "FTP". It's a little harder to get the hang of the command-line, but once you do, it's much easier to use and maintain than VB modules.And if you need to do this in SQL Server 2000 or earlier, there's this:http://www.sqlteam.com/item.asp?ItemID=6002 |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-09-17 : 18:55:54
|
| Or thishttp://www.mindsdoor.net/#FTP==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
FTP Connection