K
Kjell
Hi
Why has the database size so big difference between upgrading a ver97 to
ver2000 and building it from scratch in ver2000, the content is the same.?
It's an Access97 replicable database that I upgraded to Access2000 by using
the biult in tool in Access2000 for upgrading, but I also wanted to redo the
design.
Since I have good experience with VB6 I created an application that builds
my database from scratch and then moves all data piece by piece, record by
record. When all testings are done I must upgrade 5 identical replica sets
and this is the best way to make sure the design will be the same in all 5
sets.
But now I discovered that the size of my new built Access2000 was 20Mb
bigger than the upgraded version, it's 41Mb for the upgraded and 65Mb for the
new built, and I know that content is the same.
This is not logical to me since I know the following.
- I downsized several numerical fields from Double to Long, long to Integer
aso
- I removed like 20-30 fields not needed, some of them with 10000+ records
Having like 41Mb vs 65Mb thats close to 50% in difference, and of course, I
have repacked the files before judging the result.
What part of Access2000 am I missing when upgrading????
Why has the database size so big difference between upgrading a ver97 to
ver2000 and building it from scratch in ver2000, the content is the same.?
It's an Access97 replicable database that I upgraded to Access2000 by using
the biult in tool in Access2000 for upgrading, but I also wanted to redo the
design.
Since I have good experience with VB6 I created an application that builds
my database from scratch and then moves all data piece by piece, record by
record. When all testings are done I must upgrade 5 identical replica sets
and this is the best way to make sure the design will be the same in all 5
sets.
But now I discovered that the size of my new built Access2000 was 20Mb
bigger than the upgraded version, it's 41Mb for the upgraded and 65Mb for the
new built, and I know that content is the same.
This is not logical to me since I know the following.
- I downsized several numerical fields from Double to Long, long to Integer
aso
- I removed like 20-30 fields not needed, some of them with 10000+ records
Having like 41Mb vs 65Mb thats close to 50% in difference, and of course, I
have repacked the files before judging the result.
What part of Access2000 am I missing when upgrading????