Reconnecting after ODBC timeout

[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

 

[darkknight56]

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

Try the SQL_ATTR_QUERY_TIMEOUT ODBC variable.

Patrick Reynolds

 

[bokims]

Try the SQL_ATTR_QUERY_TIMEOUT ODBC variable.

Patrick Reynolds

 

[Brent Spaulding \(datAdrenaline\)]

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! ...