Update Delays

You can set up a data source with a page timeout that retains a page in its buffer for a period before it is removed. Specify a page timeout either with the Page Timeout option in the Driver Options section of the Data Source Setup dialog box, or through the PageTimeout keyword in a call to SQLConfigDataSource (see the next section, “Creating .Mdb Files Programmatically”). A page timeout can cause undesirable delays in updates. To specify that there be no delay in updating when you are using the Microsoft Access Desktop Database Driver, set the SafeTransactions data source setup option to 1, and set PageTimeout to 0.