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

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

"Nigel" wrote:

> 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