Microsoft KB Archive/264975

= ACC2000: Refresh Interval Does Not Work in Access Project =

Article ID: 264975

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.

Additional query words: pra RefreshInterval

Keywords: kbbug kbnofix kbclientserver KB264975

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.