Copy File and Rename it

[infinitx]

Hi,


BACKGROUND

I have a back-end database (database_be.mdb) in a folder (C:\Access).


GOAL

I want the user to be able to enter the name of the new back-end that they want to create. Then, when the user clicks a button, the program will create a copy of "database_be.mdb" but change the filename of it to the name specified by the user. So if the user typed in "Calculus" in the textbox, then the copied database' filename would be "Calculus_be.mdb."


Can this be done?


Thank you very much

 

[pbaldy]

You can use FileCopy to copy the file. You should be able to grab the user's input and use it in the code to name the copy whatever you want.

 

[Mile-O]

There's also the FileSystemObject:

http://www.access-programmers.co.uk/forums/showthread.php?t=79266