Originally posted by bodvoc
Done all that.. but can't remove my tabs as the db uses them to show data of the same type in one location... Thanks for the tip though
Not sure how large the database is but try the following:
Use this on a copy of the database.
Open the copy and rename the autoexex macro so the db would not start automatically and close the db.
Create a shortcut to the copy of your mdb.
Open the properties of the shortcut.
In the target, enter the following:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Documents and Settings\yourusername\Desktop\Yourdb.mdb" /decompile
Check the path to access and to the copy of Yourdb.mdb and the name you give to the copy and close the shortcut.
Double click on the shortcut to open the copy of the db.
Open a module and select the menu Debug and compile the database.
Close it and look at the size. It should have decreased a lot.