Create New Database

[Guest]

I have a data file lets call it data.mdb, and I have a front end data base
called forms

What I want to be able to do is automatically create a copy of the data.mdb
file called data2.mdb when I click a button on the forms database.

Is there anyway this can be coded

 

[Guest]

Nigel,

Try this

Private Sub cmdBackup_Click()
Dim fs
Set fs = CreateObject("Scripting.FileSystemObject")
fs.CopyFile "c:\tempfolder\data.mdb", "c:\tempfolder\data2.mdb"
Set fs = Nothing
End Sub

Ken