error 70

[pooja02]

I want to copy a microsoft access database (xxx.mdb)
when I write the code
FileCopy ("C:\PAPER4\db1 .mdb"), Lblpath.Caption & "\paper4.md b"
, It displays "run-time error 70 , Permission denied "
What do I do in order not to have this error, please help!

[QVeen72]

Hi,

If Database Connection for that Database is open, or u have opened the Database in Access/Visdata/Dataproject... U cannot Copy the mdb file, U have to close the ADO or DAO (whatever Conn) u have opened in Proj, and close all the connections for that mdb, and u can use "FIle Copy"

REgards
Veena