No reduction of file size

[Guest]

I have created a new database program but the file size is 17mb, when I make
it into mde it is still 17mb. I have another program that i created before,
it has much much more forms and tables and modules but the file size is only
7mb in mdb and only about 4mb in mde. Does anyone know what is happening to
my new database? Is their something that I forgot to set?

Thanks!

Tommy

 

[Larry Linson]

MDE does not, repeat NOT, imply a smaller database.

The fact that you had one before that shrank when compiled to MDE doesn't
make that a general rule. Making an MDE "compiles" the VBA code to
"tokenized" form, which may or may not be smaller, and doesn't change
anything else.

Larry Linson
Microsoft Access MVP