Can reducing number of tables improve performance?

Hi,
There are several TEMP tables in my Access database that have essentially the same fields, but are used to support different reports. Each table is emptied and recalculated each time the corresponding report is run. Would there be any performance advantage if I consolidated these tables into just one TEMP table to support all the reports?

I know the process of generating a report wouldn’t change at all, but my database would have fewer objects and the database size would be smaller…

Also, I could conceivably reduce the number of queries by using VBA to specify query parameters- would this make a difference?

The short answer is yes. But more importantly to keep your database at a minimum you will need to compact regularly if you are deleting records from tables and then refilling them with new records. Memory allocation that holds deleted records is not freed up until you compact.

BTW I am not sure the necessity of using temp tables to create your reports from, generally you would use queries or recordsets to populate your reports from your data tables. I generally perfer using vba to create recordsets rather than having a bunch of queries to maintain whenever practical.

lwells