473,387 Members | 1,542 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Database size doesn't decrease when Objects are deleted

171 100+
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
3 2833
NeoPa
32,556 Expert Mod 16PB
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
ChipR
1,287 Expert 1GB
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
32,556 Expert Mod 16PB
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

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

Similar topics

6
by: Peter Abel | last post by:
I have an application, which is an instance of a class with a deeply nested object hierarchy. Among others one method will be executed as a thread, which can be stopped. Everything works fine...
2
by: Sue | last post by:
I have a large database currently using up 30GB of space -- problem is, I am running out of space on my harddrive and so have to do some cleanup. One of the tables has a blob field and I find that...
7
by: Danny J. Lesandrini | last post by:
I know this has been discussed before, as I've seen the Google posts, but they all leave me with an unanswered question: Does my DAO code executed in the front end cause the back end to bloat?...
7
by: Terry | last post by:
I am a relative newcomer to database applications and am in the process of creating a simple database which tracks Student Details and Exams. My database has: 3 Tables (about 100 records in...
10
by: john_liu | last post by:
I use a MS ACCESS database with the size of 250MB. The dababase consists of 60 tables and no other objects. The objects in this database can not be changed. I wanted to reduce the size of database...
3
by: Nitin | last post by:
I am using access database for my application, whenever I insert records the size of the data base increases, But when I delete the records the database size does not decrease. What is the...
3
by: Knick via AccessMonster.com | last post by:
I am novice to MS Access Development, I regularly back my access database every 2, 3 days ...today when I was going to back my database I saw the access file on the network drive was only 9 MB...
5
by: Wayne | last post by:
I have been trying to get to the bottom of some bloating that I have in a frontend database. I started deleting objects a few at a time and have now deleted all objects and custom menu bars. The...
10
by: shsandeep | last post by:
The ETL application loaded around 3000 rows in 14 seconds in a Development database while it took 2 hours to load in a UAT database. UAT db is partitioned. Dev db is not partitioned. the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.