Closing DB File - Please Help - Urgent

Below is my code. I'm getting an error saying Invalid Qualifyer when I set mydb = "C:\My Documents\Programming\Bennett Auto Rebuilders\Database.mdb". What am I doing wrong?

Private Sub mnuBackupRunBackup_Click()

Dim mydb As String
mydb = "C:\My Documents\Programming\Bennett Auto Rebuilders\Database.mdb"
mydb.Close
Set mydb = Nothing
FileCopy "C:\My Documents\Programming\Bennett Auto Rebuilders\Database.mdb", "C:\Bennett Backups\Database.mdb"

End Sub

Please Help!

You're problem is that you are trying to use a .Close function on a String variable.

What is the correct code?

Thanks!

Somewhere in your program, you have presumably opened the database as a connection object. The connection object is the thing you have to close.

Thank you DerFarm.

What would be the code I used to do this?

Thank you DerFarm.

What would be the code I used to do this?

I don't know which version of VB you have but this is one way to connect to an Access database from VB6 Enterprise addition.

:D