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

 

[Jeff Boyce]

Already answered in .tablesdbdesign. Newsgroup protocol asks that you not
post separately to 'groups. Instead, select as many groups as are
appropriate (usually only one) in the "To:" -- this will allow a response in
one newsgroup to show in the others to which the question was posted.

Good luck

Jeff Boyce
<Access MVP>