Access & ODBC errors

S

Suzanne

Hello,

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.

I successfully tested the connection through ODBC Test.
When I went to open the table, I received the error. I
kept trying and at one point 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top