Access sometimes hangs on ODBC
Hello,
I'm using Access97 for an application I'm building. I need to retrieve data from a DAC computer so I use ODBC to connect. The connection's working fine and I'm able to retrieve data using SQL instructions, but there's one big problem. If somehow a SQL instruction I build has a fault or if the DAC is not able to deal with the SQL instruction Access hangs. I then need to shut down Access and start over again.
Is there a way to prevent Access from hanging in such cases?
This is the connection:
Set wrkODBC = CreateWorkspace("ODBCWerkruimte", "", "", dbUseODBC)
Set conDAC = wrkODBC.OpenConnection("Bron", dbDriverNoPrompt, , "ODBC;DATABASE=TRNDAC;UID=;PWD=;DSN=Setcim_DAC")
The connection is read-only. It's not possible to change that.