We are changing our application to work on Citrix, to use SQL Server, and upgrading to Word 2003. I have a line of code in our Mail Merge section to copy the Mail Merge data source to my data sources, but it is not working

copy file 'r:\templates\r08\rt_lettr.dbf' to 'c:\docume~1\%username%\mydocu~1\mydata~1'

This copy works on my local machine, but not on the Citrix machine. But I am not thinking it is Citrix related. I can copy to mydocu~1, just not mydata~1. What the copy does is creates a file mydata~1 in the My Documents folder.

When I do a ADIR from the My Documents folder My Data Sources comes back as entry with ..S.D in the 5th column of the array. So it can see the folder, just can not write to it.

Got the citrix tech to log onto the Citrix machine and when he was in DOS, he could not see the My Data Source folder from the My Documents folder. Very odd.

Looking for any help or understanding regarding My Data Sources and how to copy a file into the folder. Is there a way that I can reference the My Data Sources without using mydata~1?

Thanks

Brenda