I am having problems saving a recordset as an XML file under certain conditions. If the file already exists, an "Access is Denied" error is generated. Also, temporary files named dag*.tmp appear in the directory.

I am seeing this problem occur with an Windows XP Professional SP2 client is trying to overwrite an XML file on a Windows 2003 file server. Permissions on the file and directory are OK, I can edit or delete the file as I want using Notepad and Windows Explorer.

When I run the application locally (on the client's hard drive) and write the XML file to the hard drive, there is not an issue.

The problem did not occur using a Windows 2000 client with MDAC 2.7 RTM. The new Windows XP SP2 client is running MDAC 2.8 SP1. The same user account was used in both cases.

I have done a lot of searching on the Internet and seen only two other accounts of this behavior.

The line of VB6 code that does the writing (and fails under the conditions described) is:

Recs.Save FileName, adPersistXML

Any ideas or suggestions would be appreciated.