Is there anything I can do to keep the file size small?

[Guest]

Because I have some huge tables, so the file size is a big concern to me. The
problem I have is that it looks like after the mdb files are created, the
only direction the files size goes is increasing. For example, I have a mdb
file with just one table which is 300MB. After I delete the table. The file
size is still 300MB. Looks like the table is still in the mdb file somewhere.
Is there anything I can do to remove that table from the database completely?
Thanks a lot!

 

[Guest]

tools / database utilities / compact database

 

[Joseph Meehan]

Because I have some huge tables, so the file size is a big concern to
me. The problem I have is that it looks like after the mdb files are
created, the only direction the files size goes is increasing. For
example, I have a mdb file with just one table which is 300MB. After
I delete the table. The file size is still 300MB. Looks like the
table is still in the mdb file somewhere. Is there anything I can do
to remove that table from the database completely? Thanks a lot!

Nothing is really deleted when you "delete" it, but rather it is hidden.
Using the "Compact" command or menu selection will actually delete it. I
suggest you may also want to run a repair at the same to to clean things up
as well.