Saving a Copy of Database in VBA

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I am trying to write VBA code that will take an existing
Access database template and save a copy under a new file
name. Is this possible to do in VBA? I cannot seem to
get very far with VBA/Access Help.

Thanks,
Mike
 
Mike said:
I am trying to write VBA code that will take an existing
Access database template and save a copy under a new file
name. Is this possible to do in VBA? I cannot seem to
get very far with VBA/Access Help.
Click to expand...

Where is the code running? If it's not actually running in the database
to be copied, and all you want to do is copy an existing file -- which
is not open at the moment -- to a new name, you can use the VBA FileCopy
statement; e.g.,

FileCopy "C:\Templates\Template.mdb", "C:\Temp\NewDB.mdb"
 
-----Original Message-----


Where is the code running? If it's not actually running in the database
to be copied, and all you want to do is copy an existing file -- which
is not open at the moment -- to a new name, you can use the VBA FileCopy
statement; e.g.,
Click to expand...
FileCopy "C:\Templates\Template.mdb", "C:\Temp\NewDB.mdb"
 
Back
Top