Filecopy Function

I have a form with :

-Drive list box
-Directory list box
-Save button

The form appears when the application is closed down so that the user can back up their database file to the selected drive/directory.

The save button has the "FileCopy" function attached.

When I click on "Save" I get run time error 70 "Permission Denied". Presumably this is occurring because the application is still linked to the database. When the application is running, the .mdb file has a .ldb file with same name. I cannot copy the .mdb file until the .ldb file is closed. The connection is made using ADO.

How to I terminate the application's link to the database so that I can use the filecopy function? I have tried :

adoconnection.close
Set adoconnection = Nothing

with no success.

Try putting the close routine on the form unload event!
Then put the save button(the one with the filecopy) on another form that loads when the form is closed!

Click it and try!

I was working with a project with the same problem. Besides what Beacon says, a good prevention tip is to make sure that the database is not in use.