In Access VBA I am trying to refresh a file periodically from an external database using:
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, but I may be able to work through it if I can find the explorer.
The full article is in the attachment.
Code:
FileCopy "W:\srcdir\orders.btr", "C:\tgtdir\orders.btr"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, but I may be able to work through it if I can find the explorer.
The full article is in the attachment.
