Question....

  • Thread starter Thread starter skc
  • Start date Start date
S

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
 
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>
 
Back
Top