Access 2002 Programming by Example

Using Automation to Meet Performance Demands

Suppose your boss comes to you, complaining that your Access database is growing too large (some of the tables contain more than 30,000 records). Your company is considering purchasing SQL Server, but it will not happen for at least a year. The users are starting to complain that compacting takes too long, even on their fast machines. To make matters worse, they are beginning to notice degradation in query performance.

You have already implemented the performance tips presented in this book. Although these techniques improved performance, they are insufficient in light of the fact that the database is growing so rapidly. The users explained that, although many of the tables were old, they could possibly ...