|
vb123.com |
|
|
Home Contact Us Order Software Search vb123 The Magazine that Access Developers loved to read and write for is back Article Index Here or Purchase Here
RSS &
Newsletter
Get Good Help
Like FMS Products? The Toolbox About The Editor Garry
Robinson writes for a number of popular computer magazines, is now a
book author and has worked on 100+ Access databases. He is based in
Sydney, Australia
|
The
Persistent Caching (article in
PDF format)
"The Access 2007 version of this article and download is in The Toolbox"
Take a Load Off Your Server with Access 2000+. Includes examples of using XML in ADO.
Access 2000 allows you to generate persistent recordsets that can be stored on a local drive. This article demonstrates how to use these local recordsets to cache information for display in ComboBoxes or ListBoxes on Access forms.
An example of why this is important is a ComboBox that displays U.S. Post Office Zip Codes. If 25 local machines query the network database to get these Zip Codes every time they open a particular form, data traffic would slow the server unnecessarily. Using persistent recordsets, this can be handled locally. Processing Regnow E-Mail Orders using Outlook and Access The data can then be updated every week, or on demand.
Read the article in PDF format here
Click here
for the download file if you own "The Toolshed"
Else click here
Other Related Pages
Setting Database Properties In Remote Databases
Backing Up Your Access Data With XML
Published 2000-04