Q
Problem solve Get help with specific problems with your technologies, process and projects.

Access time-out limit

We have a few SQL databases, one of them is using Access as the API and is used by the whole company (more than 100 people). However we have only about 50 licenses. The server configuration has no connection time-out limit (It is set to 0). At busy times, users who have this database open often find after a period of non-activity (normally around 10-15 min) all the fields have the "Name?" in them, and all the data is gone. Once they close the table and go back in again, the data will reappear. Is this the default time-out setting? Is there a way we can configure this?

This is a known Access bug. I first encountered this about 2 years ago. There is a KB article about it, but I can't locate it at the moment. It had something to do with vesion of Access along with MDAC version.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close