Database Size

[Neily]

Hi,

I designed a database into which I loaded a good number of
records taking the size of the database up to around
128Mb. After this I deleted all the records and expected
the size to come back down as well.

Does anyone know if this is normal and if not does anyone
know what is causing it. I'm running it on Windows NT.

Thanks

Neily

 

[Cheryl Fischer]

Access does not automatically release the space consumed by deleted records
or objects. To recapture that space, do a Compact & Repair.

 

[Joan Wild]

You need to compact the database. Tools, Database Utilities, Compact and
Repair.

 

[Neily]

That's braw, thanks.

Learn something new everyday.

 

[phillipss]

I found this out the hard way. Even though you may delete
the records in a table OR delete the table, Access does
not free up that space. The database needs to be deleted
and you can start over from there. The max size for the
database is 2g. I am tring to find a way of automatically
deleting a database then recreating it but have had no
luck, so far.

 

[Kevin3NF]

The database needs to be deleted?

Why not just compact and repair?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[John Vinson]

I found this out the hard way. Even though you may delete
the records in a table OR delete the table, Access does
not free up that space.
Correct.

The database needs to be deleted
and you can start over from there.

ABSOLUTELY INCORRECT.

Tools... Database Utilities... Compact and Repair Database recovers
the lost space, and it's basic, routine maintenance for any database.

A2000 and later have an option to automatically "compact on close".