ACC2000: Changing Data Link Property for Connection Timeout Drops Connection

ID: Q216942

The information in this article applies to:
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.

Additional query words: pra prb 


Keywords          : kbdta AccessCS 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: August 3, 1999