Backup Current DB ?

[SKing44]

I hope somebody can answer this.....

I am trying to create a function which will back up my currently open DB upon request, but not to the same file, for example My DB is H:\Files\DB\Sample.mdb, and I want to save it to C:\Files\Backup\sample.mdb (As the same file name).

Can this be done in Access 97 ?

Thanks

 

[tomschafer]

Try this...


Sub BackUp(strBackupFile As String)

FileCopy CurrentDb.Name, strBackupFile

End Sub

For example...

BackUp "C:\Files\Backup\sample.mdb"