Al,
Are you sure that my.dbc is really closed? For debugging purpose, try to put a DBUSED("my") before attempting to copy the dbc. I've had situations where a CLOSE DATABASE ALL didn't close all open DBCs. Are you using a private datasession? If you're using a private datasession and my.dbc is already open when you call the form, then a CLOSE DATABASE ALL in the form won't close the open dbc. If this is the case, change the form's datasession to default.
Just a guess.

>Hi John,
>
>Thank you for your reply. The copy is from one .\data\ directory to another on a network machine. My workstations use a local resource file, differently named. In fact, the copy of *.dbf and associated files works OK. The lines that fail are specific filespecs - COPY FILE d:\thispath\data\My.dbc TO d:\thatpath\data\My.dbc and the dcx and dct, just those three files.
>
>I can shuffle the copy order and the results are the same. I shutdown all other workstations. I have run the code as methods, separate .prg, shell out to RUN commands, all the same. It works correctly when I run the form in design mode. When I DO MyMain it reads an .ini, logs in, which is checked against MyUsers, which is in My.dbc, but it is then closed, then to the menu where I call the form.
>
>This app runs on a LAN, works with a Citrix server, has a few hundred users all day state-wide and has been in production for nearly a year, daily backups and all that, so I don't think it ia permissions or rights issue.
>
>It really has me baffled. Thanks for your help
>
>Al Allison
>
>
>
>>Here's a stab in the dark, but if you have SET RESOURCE ON, the FOXUSER files will be active. A blind copy of all DBFs and FPTS will try to copy thse files and generate the error.
>>
>>>As part of an archiving process I have a form that receives a destination directory and a time range
>>>
>>>I use mkdir() to create the desired directory tree, then COPY FILE ... to move the files
>>>
>>>copy .exe version, configs, ini
>>>copy the dbc, dcx, dct
>>>copy the dbf, cdx, fpt
>>>
>>>when I run the form from the form designer, it all works correctly, when I call it from the application menu the three database files will not copy and give me a file in use error. All of the other files copy correctly without complaint.
>>>
>>>I do not have anything in the data environment in the form, nothing is open in any datasession, no database is opened, nothing is used. I CLOSE ALL and so on. wait windows, watch windows, I cannot find anything. Nothing is open
>>>
>>>What am I missing??
>>>
>>>tia
>>>
>>>Al Allison