Error 3349: Numeric Field Overflow on Make Table Query
I have a number of queries which analyse data in a Link table and then split the results into sub-tables using a Make Table Query. The process of running all these queries is done using a simple Macro. When I run the Macro the first time it works fine but if I try to run it again it stalls with the above error. In order to make it work again I have to tell each Query the name of table it is going to make - even though in theory it already knows as it suggests the name before I type it.
Does anyone know a good way to stop this from happening so that I can run the Macro over and over again?