Access Database Size Drastic Increase.

[GPGeorge]

I recommend deleting the temporary BE at the start rather than at the end. This gives you better ability to test.

What would you be testing?

In the demo, the code checks for the existence of the side accdb, then if it's found, deletes it and creates a new one. I prefer not to leave orphan files sitting around in a folder between sessions.

 

[AngelSpeaks]

Update. I removed that huge table. I'm running the export off an query that does reference a smaller table that used just for this).