From Access 2007, I am using the DoCmd.TransferText method to export data from a table in Access to a txt file located under my C drive. During the export process from Access 2007, I just started getting an error message which reads: "The Microsoft Office Access database engine could not find the object 'copies#txt'. Make sure the object exists and that you spell its name and the path name correctly." Yes, the "#" sign is shown in this message. The actual name of the file is "copies.txt". Somehow during the export process from Access, the copies.txt file continually gets deleted from my hard drive. When I recopy it back in from another folder, the same thing happens each time. When I open up the Word Merge document, after I have recopied the copies.txt file back over to my hard drive, the Merge letter still works perfectly. So the problem must be eminating from Access 2007.
This problem just started happening within the last week.
Can you help?

Set a breakpoint at DoComd.TransferText and, when it breaks, verify that the file has (or has not) already been deleted. You need to pin down exactly which line of code might be doing the damage. Keep setting breakpoints until you've pinned it down.

Have you already done this?