O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

REPLICATING TABLES FROM BACK END TO FRONT END FOR BETTER PERFORMANCE

Some tables are updated only once or twice a week, if that often. These semi-static tables could be brought into the local database and increase performance because local tables generally are faster to access than linked tables. Such semi-static tables aren't quite static enough to keep them only in the front end. The solution to this is to replicate them from the back end to the front end when the back-end version is updated.

Tip

This works great for Access-based back ends, but performance will probably be better if you leave all the tables in the back end when it's a SQL Server back end. This is because when you have queries with the data located in more than one location, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required