I thought this was the correct way to create a clone of a database. However, I keep getting the message :
"Object variable or With Block not set. "
This is just the way that it is shown in VB Help

Private Sub CmdBackUpDataBase_Click()
Dim rstTemp As Recordset
Set rstNewCopy = rstTemp.Clone

End Sub

I get the same message with

Private Sub CmdBackUpDataBase_Click()
Dim rstTemp As Recordset
Dim rstNewCopy As Recordset
Set rstNewCopy = rstTemp.Clone
End Sub

Any ideas?