Export text file from MS Access to Public Desktop in Windows 7

[gregch]

I would like to export text data from MS Access using VB code. The export file needs to go to the public desktop directory in Windows 7. There are some permission issues when I do this. Has anyone been able to work around this?

Thanks,
Greg

 

[boblarson]

What is the code you are attempting to use to go there?

 

[gregch]

This is what I am using:
DoCmd.TransferText acExportDelim, , "Qry_Inspection_Export", "c:\users\public\Desktop\" & stpathname & "" & lvalue & ".txt", False

If I change the code to point to my user ID, it works fine.