Back End Access DB - should the Front End contain temporary tables

[billelev]

Hi,

I am experimenting with using a back-end for a database I am designing.

Three of the tables in the back-end contain information that is (currently) updated on a record by record basis. I am wondering, given that there are so many calculations and insert/update queries, whether it would be "better" to create three temp tables in the front end, store the data in the temp tables during the calculation, and then move it over in one step.

Thanks,

[FishVal]

Sounds like a very good idea.

Regards,
Fish

[RuralGuy]

I would put my temporary tables in a separate MDB and delete it when I was done with it. That keeps the bloat in one place that is deleted.