Reconnecting after ODBC timeout

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

I have an Access 2003 database that has linked tables in a SQL Server 2000
database. My problem is that when the ODBC connection to the SQL Server
database times out, I have to exit Access and start the Access database back
up to reconnect to the ODBC data source. Is there a way that I can
programmatically reconnect to the ODBC data source without having to exit and
start over?

Thanks,
Larry
 
I have an Access 2003 database that has linked tables in a SQL Server 2000
database. My problem is that when theODBCconnection to the SQL Server
database times out, I have to exit Access and start the Access database back
up to reconnect to theODBCdata source. Is there a way that I can
programmatically reconnect to theODBCdata source without having to exit and
start over?

Thanks,
Larry
Click to expand...

Try the SQL_ATTR_QUERY_TIMEOUT ODBC variable.

Patrick Reynolds
 
Maybe you can just bind a hidden form to a small backend table, possibly
even a dummy table of sorts. I have never had the problem you've
experienced, and I practice the suggestion I have given you.

HTH! ...
 
Back
Top