I have a user that is using a custom built Access application. This application uses links and runtime queries to an external database which is being accessed through ODBC.

For some reason, we received the following error on one of
the Access tables when the user tried to export the data
to Excel.

ODBC Connection to 'ODBC Entry' failed.

We successfully tested the connection through ODBC Test. Then when I tried to open the table that the query was based on I received the same error. I kept trying the query and then the table and then suddenly I was able to open the Access table and then subsequently perform the export to Excel.

Can anyone tell me what is happening (i.e. why the
intermittent errors) and what we can do to prevent this in
the future?

Thank you.