By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,073 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,073 IT Pros & Developers. It's quick & easy.

Database size doesn't decrease when Objects are deleted

100+
P: 171
Hi,
I have an access mdb file where I have deleted all the queries and forms, but the size of the database is still the same it was 50Mb before and it is still 50Mb now, even after doing a compact and repair. The tables are all linked so I wouldn't think they should affect the size of the database. How do I make it so if I delete an object the size of the database decreases accordingly?



Thanks
Jun 4 '09 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,709
Compact & Repair.

Where did you select for the resultant database?

I can only suggest maybe you took a wrong step somewhere and to try it again. Compact & Repair from A to B is the most reliable way I find. When you're happy with the results then delete A and rename B to A if you need to.
Jun 4 '09 #2

Expert 100+
P: 1,287
I have found that compact & repair does not actually do anything when the database resides on a network drive. It does work if I copy it to the local drive, compact & repair, then copy back to the network drive.
Jun 4 '09 #3

NeoPa
Expert Mod 15k+
P: 31,709
I regularly use it on my network and have never noticed a time when it has failed to work as expected.

It looks (two of you with similar symptoms) that there is an issue here somewhere, but although it is not as simple as accessing over a network, it may be connected somehow.

It would certainly be interesting to find the connecting link.
Jun 4 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.