database size goes on increasing

[Guest]

I have a vb application with back end database in access. Upon transactions
in the application the size of database increases to 2 to 3 times than normal
size. This will affect the performance. What is the reason? How can i prevent
to increase the size? (However, I can compact the database to reduce the
size.)

Sanjay Limbikai

 

[Joseph Meehan]

I have a vb application with back end database in access. Upon
transactions
in the application the size of database increases to 2 to 3 times than
normal size. This will affect the performance. What is the reason? How can
i prevent to increase the size? (However, I can compact the database to
reduce the size.)

Sanjay Limbikai

Access does not have a "normal" size, it increase as it stores more
data, and information like reports.

Yes you can compact an Access Database. Access, like many databases
does not really delete data, it just hides it. Compacting an Access
database will actually delete it and that will reduce the size of the file.
Quite often a back end database is repaired and compacted on a regular
schedule.