Size of a database

[adi32]

I have an Access database with linked tables with a size of 28MB (after compact and repair)
When I create a new empty database and I import all the forms reports queries macros from the first the size is 14MB (after compact and repair)
Is it normal ?

 

[dbalargin]

this is normal. The "temp" tables have not been opened in the new database yet. Once you open the new database, you will see the change in size.

 

[adi32]

i worked in this database and the size remains small

 

[dbalargin]

did you import the tables? the tables is where your largeness comes from sometimes.

 

[adi32]

no the tables are linked for both

 

[The_Doc_Man]

If you still see this much size difference, the question is, from where does the size come?

Do you have a LOT of code in general or class modules? And did you remember to recompile and save the code in the copied DB? That might make some difference (though not likely to double the size, I'll admit.)

 

[adi32]

i have a lot of code its true
Can you tell me all the procedure for importing all the database to a new empty?

Thank you very much

 

[Autoeng]

Just create a new db, open it and File - Import everything from your old one.

 

[adi32]

i found this in access newsgroups

if you are developing a database in MS Access it will grow
like crazy. This happens because Access arranges space for
new objects, but doesn't give the space free again when
you remove an object, so this way the database will grow.
Compacting will make your database smaller again, but that
isn't the main purpose of compacting. If you really want
to "fresh up" your database you must open a new empty
database and import all your stuff into that, then your
database will have its "original" size again! Don't forget
to (manually) add your references again in VBA (if you use
any special references).


is it true?