clg Posted September 24, 2003 Posted September 24, 2003 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. Quote
Moderators Robby Posted September 24, 2003 Moderators Posted September 24, 2003 Many Deletes and Inserts will grow the DB size, as well as if you store binary/images data. Quote Visit...Bassic Software
clg Posted September 25, 2003 Author Posted September 25, 2003 The program does requires lots of data updates, but no images. I have noticed that this only seems to be a problem on Windows 98 machines. Quote
Moderators Robby Posted September 25, 2003 Moderators Posted September 25, 2003 I doubt that it has anything to do with the OS. Quote Visit...Bassic Software
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.