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!