Saving a Copy of Database in VBA

[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

 

[Dirk Goldgar]

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.

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"

 

[Guest]

-----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.,

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