ACC2000: Changing Data Link Property for Connection Timeout Drops Connection (216942)


The information in this article applies to:

  • Microsoft Access 2000
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).

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.

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.

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.
Modification Type:MajorLast Reviewed:6/28/2004
Keywords:KbClientServer kbprb KB216942
©2004 Microsoft Corporation. All rights reserved.