Automate User Option to Move files from one server location to another

[jsadler]

I am fairly new to databases and have goolged for this question. I have a database created that will keep track of drawing files in our archive. What I would like to do is, give the end-users the option to type in the file location and click a button to copy there files from their project folder directly to the archive directory on the server.

Would this be fairly easy to do or would it require the assitance of a access database programmer? Thanks for any help.

 

[RuralGuy]

I suspect part of the code will involve the standard Windows File Open/Save dialog box. As to using an Access programmer, you will have to decide that yourself.

 

[ejstefl]

Yes, what RG said. You'll probably want to use the Windows common control dialogs to get the old and new file locations.

Then, you can use the VBA command "FileCopy" to copy a file, and "Kill" to delete a file.

"MkDir" will made a new directory.

You can use "Dir" to check if a file or a folder exists.

 

[ghudson]

Did you try either of these from within this forum?

Creating an Xcopy Command

Copy files from one directory to another directory