frontend size increases heavily

[JamieC]

Hi,

I got a question related to a database with a frontend and backend.

It seems that every time I make a minor adjustment to the frontend its size increases.

i.e. My frontend was about 2 MB. I made an extra report which I later removed. I quit access and look at my frontend database, the size is now allmost 6 mb!

How is this possible?

 

[KenHigg]

You should be able to compact it and get it back down...

 

[JamieC]

Ahhhh that did the trick!

Thanks!

 

[workmad3]

If you are using Access 2000 or greater, find the option to turn on compact on close. That way, the frontend will be compacted every time you close down, and no more worries at all about the file size growing when you delete things

 

[Bigmo2u]

If you are using Access 2000 or greater, find the option to turn on compact on close. That way, the frontend will be compacted every time you close down, and no more worries at all about the file size growing when you delete things

Call me stupid but how do you do that? I know where the utility is in access but how do you turn it on for it run on close?

 

[WayneRyan]

Big,

Tools --> Options --> General (Compact on Close)

Wayne

 

[Bigmo2u]

Wayne - thanks for the help it is greatly appreciated.

 

[ghudson]

Here is another twist...

compact and repair database