Importing all objects

[giedrius]

Hi all,

I was wondering if you could point me to a good add-in which would enable to copy all the objects from one data base into another. Honestly, I got sick with all those bloating issues and after having read most of what is available on the net and some experimenting by myself I came to a conclusion that the only reliable way to free space in a database is to copy it to a new one.

Importing the database using A2K menu command in no good as it does not provide copying of the required references.

giedrius

 

[ghudson]

I disagree. All you have to do is compact the db. Access 2000 and newer has the option to compact the db when the db is closed.

You can compact the db yourself while you are exclusively in it or you can use Microsoft's "free" Jet Compact utility. You will not loose any relationships using this program.

Access 97: Updated Version of Microsoft Jet 3.5 Available for Download

Access 2000: Jet Compact Utility Available in Download Center

Access 2002: Jet Compact Utility Available in Download Center

I prefer to use a custom shortcut to repair and compact my db's. Here is a sample Target field to do just that for a secured db...

"C:\Program Files\Microsoft Office\Office\msaccess.exe" /wrkgrp "X:\MyWorkgroupFile.mdw" "X:\MyDatabase.mdb" /user MyUserID /pwd MyPassword /excl /repair /compact

 

[giedrius]

Well, I've been developing my application's front-end (FE) every day for quite a while. After I finish my day's work I would always first compact the database, then exit. Little by little my FE grew to 10 MB. One day my FE grew by some 3 MB and I got suspicious. During that day I didn't add many new controls into my forms but rather was doing some clean up - moving and/or deleting some controls and instead creating the new ones. I then copied all the objects into a new database. And guess what? My FE contracted to some 2.5 MB.

I also read about undocumented /decompile switch and was using it for my FE. Compacting with /decompile switch was much more efficient, but I never managed to compact my FE down to some 2-3 MB.

giedrius