Thanks Jof - I am trying to avoid having a password 'stored' on the machine (unencrypted) so thsat the user has to type it in each time. If I read your idea properly the password would be in a csv file, so I gain no security over having it in the batch file lines?
The file is to be run via a desktop icon, but at the moment I am testing it via the 'Run' command in XP. I don't think I'm making a 'form'! It does not halt while the ftp transfer takes place before calling 'access' at the moment and I have already tried 'pause' with no effect. I have tried it after the 'upload file' line and it just goes straight past while uploading.
This is the relevant part of the file so far
::Variables
set f=%temp%\ftpc.txt
echo open THE.FTP.SERVER.IP>%f%
echo user USERNAME PASSWORD>>%f%
echo binary>>%f%
echo cd REMOTE_DIRECTORY>>%f%
echo cd Out>>%f%
echo lcd LOCAL_DIRECTORY>>%f%
echo put FILE_NAME>>%f%
Tried pause here, then
echo MSACCESS PATH
blah blah
Just looking at the ftp command now.