Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Changing Data Link Property for Connection Timeout Drops Connection

ACC2000: Changing Data Link Property for Connection Timeout Drops Connection

View products that this article applies to.

This article was previously published under Q216942
Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access project (.adp).

↑ Back to the top

Symptoms

Using Access Client/Server, if you try to change the Data Link property for Connection Timeout, the connection is dropped and re-opened; this forces edited objects to be saved and automatically commits uncommited records.

↑ Back to the top

More information

Steps to Reproduce Behavior

1.Create a new Microsoft Access Project.
2.On the File menu, click Connection.
3.On the Connection tab, enter valid information to connect to the Microsoft SQL Server sample database called Pubs.
4.On the Advanced tab, set the Connection Timeout to 0 and click OK.
5.Open the Employees table in Datasheet view.
6.Edit a record but do not commit the changes; that is, leave the record in edit mode.
7.Minimize the Datasheet.
8.On the File menu, click Connection and click the Advanced Tab.
9.Set Connecion Timeout to 15 and click OK.
Note that the Employees table has been closed. As the connection is dropped and re-estabilished, all objects need to be saved and closed; hence, records in an uncommited state are automatically committed.

↑ Back to the top

References

For more information about Access projects, click Microsoft Access Help on the Help menu, type Access projects in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top

Keywords: KB216942, kbclientserver, kbprb

↑ Back to the top

Article Info
Article ID : 216942
Revision : 2
Created on : 6/28/2004
Published on : 6/28/2004
Exists online : False
Views : 321