Permission Denied --- FileCopy Statement

[lcuadrado]

Hello everybody:
I want an application to do a copy of a *.mdb file in a floppy disk using the FileCopy statement. After I made some changes in the database with the application and after I made the FileCopy statement, I get the error "Permission Denied". Even after I execute the FileCopy statement, I close every connection to the database. The code where I do the FileCopy is right below:

sourcefile = "C:\CLIENTS.MDB"
destinationfile = "A:\CLIENTS.MDB"
FileCopy sourcefile, destinationfile

Also, I tried to made a duplicate in another location in the hard drive and I keep recieving the same error. Is there something that I need to do? Any answer is welcome. PLEASE THIS IS VERY IMPORTANT. I'M ALL TIED IF I DON'T SOLVE THIS PROBLEM. Have a nice day everybody.



Luis E. Cuadrado

[Tygur]

Make sure the disk isn't write-protected, if you didn't already. (That's all I can come up with)

[lcuadrado]

I already check the floppy disk and is not write-protected. Also, I tried to copy the file in another location in my hard drive and I still have the same problem. PLEASE HELP!!!

[Nucleus]

Can you do the same process manually?

[DigitalD0g]

Is the file itself set to read only?

[Tygur]

DigitalD0g,
If a file is read only, it only meand it can't be changed. It can still be copied. Test it out. Try using FileCopy to copy a read only file. It'll have no trouble copying it.

[DigitalD0g]

Tygur,

LOL... I actually knew that, I just wasn't thinking. Files on CD-Rs are Read Only and they can be copied.

I guess the next questions would be:
Is the floppy damaged? Can copies of different files be made from the same, or other floppies?

[scoutt]

Sounds like the database is still resident in memory somewhere. see if you can copy the file manually, without the program, as Nucleus suggested.

Scoutt

[DigitalD0g]

A reboot should clear it from resident memory if that is the problem.

[reivaJ]

maybe it is because the file is in use

[lcuadrado]

reivaJ is right. I didn't realize that the file was in use by Visual Data Manager. As soon as I close the Visual Data Manager window, the FileCopy statement worked just fine. I want to thank all the people that help me with this problem I really appreciate it. See ya soon.