Search code examples
databasems-access-2010filesize

How To Reduce Database Size


So I've had a database for some time now, accumulated some 20 tables with a variety of records per table.

I've since made a copy of the database and pretty much gutted everything except one table, with 5 records currently.

Then I happened to notice the file sizes. I assumed by removing a ton of unless information my database size would be reduced, however it stayed the same.

Why is that? Can the size be reduced somehow?


Solution

  • In the File menu, select Info, then click the Compact & Repair Database button.