Web Development

Ask something
Discussion Locked

MS Access database

0 helpful
2 replies

by acqanal

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a simple database that stores and retrieve data, driven by forms, controls, queries etc. Each time I run the application the file size of the database gradually increases. Why is this, and how can I prevent it from happening?

Currently, everytime I exit from the database, I have to manually do a 'compact and repair database' from the Database Utilities options in the Tools menu.

2 replies

by brossyg9

In non-tech terms, Access bloats over time. You can set it the compact 7 Repair on close automatically in the options tab.

This discussion is closed to new replies.