Reducing the size of the application

Colin Coleman

Registered User.
Local time
Today, 13:07
Joined
Jul 25, 2008
Messages
27
I have inherited a Access 2007 Application and want to seperate the data from the "program", i think i have done this using the Database tools-->Move data --> Access database,

The original database "app" was about 80Mb and after using the above function/wizard its shrunk to only 59Mb. and the extracted Db file os only about 6Mb

i would expect the App with the data removed to be a couple of Meg,
Have i missed something, or do i need to purge the data from the data-less App ?

Thanks
Colin
 
Nope, But i guess im gonna be doing it soon, ....So pray where does one find Compact repair ?

Many thanks
 
Found it under the Magic "splat" then Manage....Cool its now shrunk from 66Mb to 907Kb...I am impressed, now i can email it....
Thanks Guys and Galls
 
Assuming you are using 2k3 (though it should be about the same for other versions), it is Tools...Database Utilities...Compact and Repair Database.
 
Ack, a simulpost. Good to see you found it, though.
 

Users who are viewing this thread

Back
Top Bottom