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.
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.
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"...
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"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.