Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How can I reduce MS Access file size after deleting the data?
I had a huge MS Access file (.accdb) with the huge data. I deleted some of the unneeded columns and saved the file, but the size of the file did not change. What can I do to reduce the file size? Can you tell me what's wrong?
2 Answers
- 1 decade agoFavorite Answer
From MS Access HELP File:
Compact and repair a database that you have open
Note If other users are also currently using the database file, you cannot perform a compact and repair operation.
Click the Microsoft Office Button , point to Manage, and then, under Manage this database, click Compact and Repair Database.
Compact and repair a database that is not open
Note If other users are currently using the database file, you cannot perform a compact and repair operation. While you run the compact and repair operation, no one can use the database file.
Start Access, but do not open a database.
Click the Microsoft Office Button , point to Manage, and then, under Manage this database, click Compact and Repair Database.
In the Database to Compact From dialog box, navigate to and double-click the database that you want to compact and repair.
- Anonymous1 decade ago
Tools - compact the file.
