ACC2000: Refresh Interval Does Not Work in Access Project (264975)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q264975
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

You notice that the Refresh Interval in your Access project (.adp) does not appear to work.

CAUSE

The Refresh Interval is ignored in Access projects. This setting works only in Access databases (.mdb).

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample Access project NorthwindCS.adp.
  2. On the Tools menu, click Options. Click the Advanced tab.
  3. Change the Refresh Interval to 1 minute, and then click OK.
  4. Quit and then restart Access.
  5. Create a new Access project named Adp1.adp. Establish the connection to the sample SQL Server database, Northwind.
  6. Open a second instance of Access, and then open NorthwindCS.adp.
  7. Open the Customers table in Datasheet view in both instances, and then size the windows so that you can see both at once.
  8. Edit a record in the first instance of Access, and then commit the changes.
  9. Switch to the second instance of Access.
Note that after one minute the table in the second instance is still not refreshed to show the data changes that you made in the first instance.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbbug KbClientServer kbnofix KB264975
©2004 Microsoft Corporation. All rights reserved.