Access Database Size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We created a new Access Database from an existing Database. We made some
enhancements to it, tested it. The last thing we did was to copy the History
Tables from the old Access database to the New database. Then we deleted the
History Tables out of the New Access Database so that we then had the latest
History Tables out of the Old database.

All of a sudden, the size of the Database doubled! It went from 286KB to
512KB. Why?!?!? It's not keeping those deleted History Tables within the New
Database is it???
 
wnfisba said:
We created a new Access Database from an existing Database. We made
some enhancements to it, tested it. The last thing we did was to copy
the History Tables from the old Access database to the New database.
Then we deleted the History Tables out of the New Access Database so
that we then had the latest History Tables out of the Old database.

All of a sudden, the size of the Database doubled! It went from 286KB
to 512KB. Why?!?!? It's not keeping those deleted History Tables
within the New Database is it???
Click to expand...

Access does not really delete data and some other stuff, until the
database is compacted. You will find the command in the tools menu.

You might note that 512KB is a small database by Access standards.
 
Back
Top