Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
When creating a new db with import why smaller?
- Thread starter gwendon
- Start date
First, it's possible to miss some things like import specifications and menus.
But more importantly, Access bloats mdb files quite a bit when you edit objects. Most of this bloat is recovered when you compact a database. But it's quite possible for the file to stay a little bloated even after a compact. Importing everything to a new database only grabs the live images of your objects, and not the junk that's still floating out there.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Professional Development for Clients Large and Small
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
But more importantly, Access bloats mdb files quite a bit when you edit objects. Most of this bloat is recovered when you compact a database. But it's quite possible for the file to stay a little bloated even after a compact. Importing everything to a new database only grabs the live images of your objects, and not the junk that's still floating out there.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Professional Development for Clients Large and Small
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Status