Move and rename File after entering into Access

[tcheck]

We track pdf reports that are entered into an Access database but are put into an inital directory that is open to the intranet (so users can get an idea of what the report is) and then copied into a different directory that we wil provide to internet users via IIS that has a unique id. I would like to build a batch file process to copy from the intranet directory to the internet directory after the information is entered into the database.



Any ideas?

Thanks in adavance.

[June7]

Google: Access VBA filesystemobject

http://www.anysitesupport.com/access...to-copy-files/

[tcheck]

Thanks. I tried the code and it errored out on rst!FileExt so I researched and found this site http://www.devhut.net/2010/09/27/ms-access-vba-rename-file/ it is much easier and works great.

My next question is how to copy directories with a space in the name. An example is Name "C:\Old Dir\Old FileName.txt" As "C:\New Dir\NewF ileName.txt"

What do I replace the spaces with?

[June7]

The spaces should not be an issue. Doesn't cause me any problems.

[tcheck]

Thanks. I tried it again and did not have issues. Must have had the incorrect file name.