Progress bar on file upload

[Rob Sang]

Hi, I have inherited a database that includes the ability to upload files to a remote server through the interface. The code for this is fairly straightforward and uses FSO. The key function call being:

fso.CopyFile (sfol & file), (dfol & strName), True

Anyway, this causes errors when users start doing more with the database before the file is done uploading. So how can I add a progress bar or wait dialogue that knows when the file is done uploading?

 

[ecniv]

um dunno - I was messing with FTP stuff through access and only got as far as connecting and browsing. I ignored the way you are currently doing it and the relative API commands as they didn't allow me to show how much of the file had gone.

I couldn't successfully open the file for read/write on the ftp, BUT on the local machine it worked fine (both the same method).

As far as I could tell there is no way of letting the user know unless you have a complete/busy flag on the FSO? in which case you'd have to check that repeatedly until it clears, and not allow the users to do anything whilst it checks.


Vince

 

[ghudson]

Will adding the DoEvents command help?

It might be safer to change their mouse pointer to the busy hourglass and also disable all buttons on the form. Give them a message box or unhide a label to alert them that the importing process will disable all db options until it has completed.