Error 462 even though all references are qualified

[AmateurPro]

From Excel I am trying to open 2 different access databases and run a macro/query in each one. Every 2nd time I run the code I get the error message, "Error 462: The remote server machine does not exist or is unavailable". According to all the help topics I've read, this is caused by not properly qualifying a new document object in my code. However, as far as I can tell, every line of my code qualifies the objects correctly...

Please Login or Register  to view this content.

What is causing the error? Please help!

[AmateurPro]

Well, I'm not sure I understand why this fixed it, but replacing the line "appAccess.Quit" with "appAccess.DoCmd.Quit" makes it work with no errors. Hope this helps somebody else some day! (This code works with Microsoft Access 14.0 Object Library selected under References in the VBA window)