will access disconnect from sql-server if it is idle?
i have multiple users 开发者_如何学Cconnecting to sql-server-2008 database. i would like to know whether they will be disconnected if left idle?
Idle Access users disconnecting have been my experience in my limited testing in the Auto FE Updater to see who is in the SQL Server database. I haven't had the time to figure out where that setting is, if any.
No, they shouldn't be, but if you're running a query against the sql server, there is an odbc timeout property that can cause the query to give up.
精彩评论