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
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical SQL Server questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our SQL Server gurus are waiting to answer your toughest questions.
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.