vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

Home Contact Us
Order our Software

RSS & Newsletter
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile, shutdown database Read and Download

The Toolshed
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More

The Toolbox
Libraries of software that we regularly import into our projects. Enhances the Toolshed More..

Upsize to SQL
Upsize to SQL Server 2005 or 2008 or improve the performance of your Access to SQL Server application
Read More

DryToast New
Backup and query your BaseCampŽ projects
Read More

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

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
Contact Us ...

Search ...

or try our new Expression Web
vb123.com.au

Persistent Caching (article in PDF format)

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

The next article in this loop

Published 2000-04