Search results

It's all on the same computer. Intel i5 with 8Gb Ram.

This is an Access front-end and Access back-end. This table is being created on the front end. Size of the dB is about 30 Meg.

Actually both. There are only two records to add but that takes 4 seconds as well

I hope someone can help me with a performance issue in creating dynamic tables using VBA. I have a generic procedure which rebuilds a table to store the contents of a crosstab query. This table is then used to populate a subform. On one particular table the code takes around 4 seconds to run –...