Runtime Error 70 in Win7 when attempting to copy files 1

[DonCoyote]

In Access VBA I am trying to refresh a file periodically from an external database using:

 FileCopy "W:\srcdir\orders.btr", "C:\tgtdir\orders.btr"

According to Microsoft article 252711, VB or VBA "attempts to invoke the methods of a secure Microft Transaction Server".
In this case, the "server" is a simple PC running Win7Pro.
The recommended solution is to assign the userid launching the application to one of the Roles authorized to invoke themethods of the MTS object. Then "Launch the MTS Explorer".

This is where I get lost. What and where is the "MTS Explorer"?
The rest of the article is arcane; I may be able to work through it if I can find the explorer, but any additional help would be appreciated.
The full article is in the attachment.

 

[JackTheC]

I don't think it had anything to do with MTS.
I think the file "W:\srcdir\orders.btr" is in use by an other
application. Open files cannot be copied.

http://support.microsoft.com/kb/147394

 

[DonCoyote]

Thanks, Jack. It turns out that both source and target were "open". Had to close the form and run the copy from another form, so it took a while to work around the restrictions and find out that you were absolutely right.

 

[dilettante]

This is not forum707.

Please put these questions over there.

 

[DonCoyote]

I understand, and thank you for your concern. The reason(s) I posted here are (a) according to the MS KB article, this appeared to be a VB problem, whether native or VBA, and (b) I had no response on the other forum.