Access Database Size Issue

[homeguard]

I just got done migrating the tables in my database to a SQL server, I went in and deleted the extra table that was created with the migration manager so all the data in my database is on a SQL Server, For some reason the size of the database is still the same. Why is that?

I even when in and deleted the tables query and forms but the size is still the same, if there some setting that im missing?

Thanks.

 

[David Eagar]

Have you done a Compact & Repair?

 

[boblarson]

As alluded to by David, the objects in Access don't react exactly as you would think. If you delete something, it does not exist in the things you can VIEW but the space that the objects took up are still as if they are there until you run the Compact and Repair function. So, any space that was occupied by those objects is not recovered until you do the Compact/Repair.

 

[homeguard]

got it, thanks guys