Recent content by willem mosterdijk

Thanks for your answer. I don't now how I can see what type of connection it is. I uses the connection wizard (ODBC) and select the Oracle driver to connect to the database. So far so good. I can work in the Access program, but sometime I receive a connection error. So if there is a VBA code...

In a access database I have a connection between MS Access and a Orcale database. Once in a while the connection dies. Does anyone know a vba code that the connection test and possibly re-create the connection as needed.