Bugging question...

[skc]

Access2000 on Windows 2000 Pro.

I have a database called A.mdb that contains 2m records
(in a table called 'one'). The size of the .mdb file is
1GB.

I delete all the records in table 'one', the size of
the .mdb is still 1GB.

This also occured when I had another database, copied al
the tables and queries out of it into a new database, and
the size dropped from 2GB to 300MB!!!

Why is this?

skc

 

[Liz]

You need to compact your db.
Tools - Database Utilities - Compact and Repair Database

You can also set the db up to Compact on close.
Tools - Options - General Tab - Click on Compact on Close

With the auto compacting you can run into problems if more
than 1 person is using the db. Read up on it in Help.

Good Luck!

 

[Jeff Boyce]

Unless you use "Compact & Repair", Access doesn't compress out unused space.
Be sure to save a backup copy before running this.

Good luck

Jeff Boyce
<Access MVP>

 

[TC]

The space that is occupied by deleted records is not reclaimed until you
compact the database (or copy the objects into a new database).

HTH,
TC

 

[frank]

Access doesn't reduce the size of the DB until it is
compacted.(tools, utilities, compact and repair)