I am running a database which outputs 'many' records that it crashes the db at a point when the output table (when saved) size reaches 1.99gb.
What I mean my 'when saved' is that; after crashing/showing error msg, I save the db and the db size is 1.99gb. This is ok since thats the maximum an access db can take.
Now what I did is, cleared the output table, and tried to run the query again and the same msg (error msg) popped up.
When I cleared the output table and saved the db, its still 1.99gb. This is why the error still showing up.
Is there anyway to make the db go down in size without saving it under different name? (considering I already cleared the output data from the output table)