I’m using Access 2000 to develop this certain system for more or less 7 months now. Let’s call my current system development database as CurrentDB.
I’m just puzzled by this occurrence:
1. I created a new blank database, let’s call this new blank database as NewDB.
2. I then imported everything from CurrentDB (my front-end) — tables, linked tables, forms, reports, macros, modules, including relationships and toolbars.
3. Set-up everything in NewDB to match CurrentDB — startup, references…
4. Opened the code window and ran Compile to prevent the nasty error of “…connection may have been lost…”
5. Lastly, compacted and repaired the NewDB, then closed it.
To me, both CurrentDB and NewDB are now the same, right? But there’s a very large difference in their file size! NewDB is only 7.6MB while CurrentDB is 18.6MB. Note that I’ve already compacted and repaired CurrentDB prior to comparison.
Could anyone explain this, I mean, how could this be possible? And, is this a safe path to tread whenever I like to have a smaller mdb?