Printable View
Hi All,
I'm working on an app in VB6 Pro that reads/writes to an Access 97 DB. When the DB was first created it was 94k. But after I run the app and clear the data from the database several times, I notice that the DB keeps getting bigger. The DB has only 3 tables and no more than 10 fields per table. At one point this DB was 20MB after I deleted all the data. Does anyone have any idea why this is happening and how I can fix it?
Thanks,
Scott
Hi Scott,
The reason it is "inflating" is because when you delete something out of access it actually isnt really deleted.
It is held in access until you "compact" the database!
So you just have to compact it!
Are you using a replica set by chance?
ciao
b :)
open the database in Microsoft Access and look for the option to compact
and there you go!
you can also compact it using VB.. search the forum, or i can post code
If something that is deleted is still in the database until it is compacted, is it possible to 'undelete' this. If so - how?
Aidan
You can compact your database form your software too... Look at the tip form vbworld: http://216.26.168.92/tips/tip482.html
It is deleted, but the space for this data is not given free.Quote:
Originally posted by aidan
If something that is deleted is still in the database until it is compacted, is it possible to 'undelete' this. If so - how?
Aidan
So unless you compact the db it keeps growing even if you delete all rows from all tables each day
Isn't that called a rollback??? I'm not so experienced in Databases, so I'm guessing here...Quote:
Originally posted by aidan
If something that is deleted is still in the database until it is compacted, is it possible to 'undelete' this. If so - how?
Aidan
I have no idea how to do such a thing though...
Wow! Thanks for all the replies... big help! I didn't know about compacting the database... doh! Anyway, thanks again, and thanks for the link to the code.
Cheers!
Scott
No problem at all...
Could you place *RESOLVED* in your subject (after the current one) so that when users search they know that this one has an answhere...
Good luck!