Hi,

I'm using a DSNLess connection from Access to SQL Server 2008R2. Works great, except after a few hours of no activity I get an error that the ODBC connection failed. How can I avoid this?

Thank you.