Reducing the size of the application (1 Viewer)

[Colin Coleman]

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

 

[Starman]

Have you done a Compact/Repair?

 

[Colin Coleman]

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

Many thanks

 

[Colin Coleman]

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

 

[Starman]

Assuming you are using 2k3 (though it should be about the same for other versions), it is Tools...Database Utilities...Compact and Repair Database.

 

[Starman]

Ack, a simulpost. Good to see you found it, though.