remote server machine error message

Question

I'm developing a macro that opens a file and then manipulates the data.  When it is finished. it saves a copy of this file as a csv file.  Then it does the same thing to a second file.   It then opens an Access database and runs several queries before importing both of the cvs files.   After that I run a number of queries and export the results back to Excel.

Sometimes during this process, I will get the follwing MS Visual Basic error message: "The remote server machine does not exist or is unavaiable".

Sometimes I get this message the first time I run it and sometimes it is after the second or third time I run it.  I don't get the message on a consistent basis.  I've also checked to ensure the database isn't already open when I run the macro (no .ldb file).

This is the code I use to open the Access database from Excel:

Set AppAcc = New Access.Application

AppAcc.OpenCurrentDatabase "R:\Macros\Comparison.mdb"

AppAcc.DoCmd.SetWarnings False

After the database is opened, I run a number of queries in the database.

I'd like to elimiate this issue but am not sure what to do.  Any help or suggestions would be appreciated.  Thanks.....

Answer 1

Are you having network problems, causing the R-drive to sometimes be unavailable?

To eliminate this as a possible cause, run the code entirely on your local machine.

AppAcc.OpenCurrentDatabase "C:\Test\Comparison.mdb"