F. Scott Barker’s Microsoft Access 2002 Power Programming

Chapter 26. Creating Maintenance Routines

IN THIS CHAPTER

• Creating an Export Dialog to Export Tables 862

• Compacting and Repairing the Back End on Demand 868

• Creating a Generic Code Table Editor 871

• Replicating Tables from Back End to Front End for Better Performance 874

This chapter presents some useful routines, combining ideas that I hope you’ve gleaned from the rest of book. One goal of this chapter is that, by examining and using these routines, you can continue to learn new techniques. These routines aren’t in any particular order and have diverse uses.

You can find each example in the VideoApp(ADO).mdb database in the \Examples folder on the book’s Web page at www.samspublishing.com.

Creating an Export Dialog to Export Tables

Often, it’s a good ...