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.