I am relatively new to Access programming, but I have noticed that the size of my database is growing very rapidly. I just finished a modest database and the total file size was 30MB (before any data was put in the tables). I did have quite a few reports and other bells and whistles, but it just seems really large. Is this a 'normal' size for an access database. Are there certain features that cause the size to increase dramatically?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
File Size
- Thread starter kcmark
- Start date
A little more explanation...
As you develop a database, typically you do a lot of editing of forms and other objects, adding and deleting fields in forms or reports, etc. You may create tables, populate them and then change your mind and delete them. Deleting an object does not completely do away with it. The space it occupies within your database is still occupied - just not accessible. Compacting will do the finally recovery of this space (and reduction of your database).
Even a completed database can (and usually does) increase in file size over time, depending upon what is going on such as creating and deleting objects or deleting records. So, compacting is a normal requirement in periodic database maintenance.
As you develop a database, typically you do a lot of editing of forms and other objects, adding and deleting fields in forms or reports, etc. You may create tables, populate them and then change your mind and delete them. Deleting an object does not completely do away with it. The space it occupies within your database is still occupied - just not accessible. Compacting will do the finally recovery of this space (and reduction of your database).
Even a completed database can (and usually does) increase in file size over time, depending upon what is going on such as creating and deleting objects or deleting records. So, compacting is a normal requirement in periodic database maintenance.
I can see 1664 Access databases on my shared drive. 1500 are less than 30Mb. The largest is 1074Mb.
Jet always adds new records at the end of the tablespace ie it never goes back and re-uses the space from deleted records (which I find odd - you think it would always have a look for space on the current page). Compacting takes all the records out and re-loads them into the tablespace thus recovering unused space.
Jet always adds new records at the end of the tablespace ie it never goes back and re-uses the space from deleted records (which I find odd - you think it would always have a look for space on the current page). Compacting takes all the records out and re-loads them into the tablespace thus recovering unused space.
- Status
Similar threads
- Locked
- Question
- Locked
- Question