After deleting a large table the file size for the db does not de.

[Guest]

I am using MS Access to query a large database. Due to this, I sometimes
create interim tables to use in the query process. When I have retrieved the
final result, I will delete these somewhat large tables. The problem I am
encountering is that the file size for the database expands with each table I
have built, but does not decrease with the deletion of these interim tables.
This causes the file to grow large and take up a lot of disk space. My answer
in the past is to copy my queries to a new database and then delete the old.
This tends to manage the file size, but as my query list grows the task is
becoming time consuming. Any suggestions would be helpful. Thanks.

 

[Rick B]

Just repair and compact your database. That will restore that cleared up
space that Access still has reserved.

Rick B

 

[Guest]

Thanks Rick, The actual problem stemmed from the ODBC links that I had to the
MS Access database. The compact does not work when linked in that way. Once I
removed the links, then ran the compact routine, the database recovered and
is working great. Thanks for your quick response, it is appreciated. ShonaS