If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
General Compact/Repair Question
We all know that Access mdb apps bloat with use and must be compacted
periodically. I think I read somewhere why this happens but I can't recall. On an app I am working on, I noticed I was up around 50MB and compacted before I had to send to another developer by email. Compacting reduced it to about 10MB(zips to about 3MB). For some reason, I decided to create a new database and import all the objects from the app. The size of the resulting database is only about 5MB, which after zipping to about 1MB (which made the other developer happy, as he only has dial-up connection, and smaller emails are better). I was curious if anyone knows why compact method doesn't reduce the size to something similar to that when all the objects are just imported into a new database? -- dchman |
#2
|
|||
|
|||
General Compact/Repair Question
The code behind all Access Objects (forms, reports, code, etc.) are stored
in two ways: text and compiled. Before Access can use any of these objects, they have to be compiled. (Access does this automatically when you first run the app.) This compiled code takes up space in the database. When you create a new database and copy all the objects, you only copy the text version, not the compiled version. Therefore it is smaller. My guess is that the first time the developer opens and uses the database, it will grow to 10MB (or there abouts). This working space is not considered "bloat". -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "dchman" wrote in message ... We all know that Access mdb apps bloat with use and must be compacted periodically. I think I read somewhere why this happens but I can't recall. On an app I am working on, I noticed I was up around 50MB and compacted before I had to send to another developer by email. Compacting reduced it to about 10MB(zips to about 3MB). For some reason, I decided to create a new database and import all the objects from the app. The size of the resulting database is only about 5MB, which after zipping to about 1MB (which made the other developer happy, as he only has dial-up connection, and smaller emails are better). I was curious if anyone knows why compact method doesn't reduce the size to something similar to that when all the objects are just imported into a new database? -- dchman |
#3
|
|||
|
|||
General Compact/Repair Question
thanks, that makes sense.
-- dchman "Roger Carlson" wrote: The code behind all Access Objects (forms, reports, code, etc.) are stored in two ways: text and compiled. Before Access can use any of these objects, they have to be compiled. (Access does this automatically when you first run the app.) This compiled code takes up space in the database. When you create a new database and copy all the objects, you only copy the text version, not the compiled version. Therefore it is smaller. My guess is that the first time the developer opens and uses the database, it will grow to 10MB (or there abouts). This working space is not considered "bloat". -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "dchman" wrote in message ... We all know that Access mdb apps bloat with use and must be compacted periodically. I think I read somewhere why this happens but I can't recall. On an app I am working on, I noticed I was up around 50MB and compacted before I had to send to another developer by email. Compacting reduced it to about 10MB(zips to about 3MB). For some reason, I decided to create a new database and import all the objects from the app. The size of the resulting database is only about 5MB, which after zipping to about 1MB (which made the other developer happy, as he only has dial-up connection, and smaller emails are better). I was curious if anyone knows why compact method doesn't reduce the size to something similar to that when all the objects are just imported into a new database? -- dchman |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
General combo box question | Jon in Canby Or. | Using Forms | 3 | January 25th, 2006 02:52 AM |
Question about the option 'Compact/Repair' database. | Pat | General Discussion | 1 | January 19th, 2006 11:29 AM |
General filter question. | rob p | New Users | 1 | December 6th, 2005 06:09 PM |
Pivot / general chart formatting question | NTL | Charts and Charting | 0 | December 5th, 2005 11:37 AM |
General Question about Froms | D Dawson | General Discussion | 4 | November 30th, 2005 08:56 PM |