Cleaning Access DB

[Ragnar78]

Hy,

I wanted to know why the access DB dosent lower in size when i delete a table...

When i started my DB, i had one table with a size of the access file 500 mb,

I added another table that made the access file 700 mb,

When i delete the second table the size stayed the same...

Can anyone tell me how to clean correctly DB to reduce diskspace usage?

Thx

 

[mdmilner]

Under the tools menu
Database Utilities
Compact and Repair Database

This may not be the perfect explanation, but Access builds a lot of indexes while it's working with the data that does not get deleted unless you compact the database. Think of it as - Access only wants to expend the processing time to do it once.

Mike

 

[Ragnar78]

Thx a lot...

 

[Legacy 15162]

how would you compact & repair a db on open?

 

[Norie]

txksa

What version of Access do you have?

In later versions there is an option to Compact on close.

It's under Tools>Options and the General tab.

I think this makes more sense than Compacting on close.

 

[Legacy 15162]

2k.....you right, it does sound more logical

 

[Norie]

2k

Well you should have the option.

 

[mdmilner]

Read this on why:
http://www.mvps.org/access/general/gen0013.htm

Then go here for A2k+
http://www.mvps.org/access/general/gen0041.htm

Or grab the A97 utility further down the page.

Mike

 

[Legacy 15162]

i set it up to do this and it works fine.