I am using an Access Database in my program. I have noticed that the file size increases very quickly after the program has been used for a short while. I can still compact the file by opening it in ACCESS, but I would like to be able to automatically compact the database each time I exit my VB.net program.
When I compact using ACCESS the file size goes from 9mg to 700kb this is a substantial difference and I have no idea why it is getting so large.
Anyone know why my file size would be increasing so quickly or if I can do a compact from VB.net.
When I compact using ACCESS the file size goes from 9mg to 700kb this is a substantial difference and I have no idea why it is getting so large.
Anyone know why my file size would be increasing so quickly or if I can do a compact from VB.net.
