473,325 Members | 2,860 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,325 software developers and data experts.

Database keeps doubling in size!! Help!

Can someone please help me! I have created a db in Access 2003 and the overall file size keeps doubling periodically. Before I noticed this phenomenon the DB was at 65Mb (could have been happening earlier). It then doubled to around 120Mb, then 241Mb and finally it was at 480Mb!! I had a back-up of the 65Mb version so I just copied the new tables/queries/forms from the latest db (480Mb) into the backup (65Mb) and it was OK for a while until it started doubling again. I tried to determine what was making it double by going through all the available actions etc but it seemed to be doing randomly! I have read on this forum something similar but the answer to that thread didnt help me.

I am a bit of a novice with DB's and i haven't split the db into Front-end and Back-end, but its quite small (around 20 tables but only 3 are of any real size, 25 queries, 20 reports, 8 modules (all performing mail-merge programmatically) and around 10 macros)

Does anyone have any idea why this is happening and how it can be prevented? I have been working on the db for months, with gradual additions to it as and when needed and so I would rather not have to start from scratch! (I am worried that my lack of db knowledge when i started may have meant i used bad practices - which is starting to manifest itself now!)
May 1 '06 #1
6 1622
cweiss
36
Try going to Tools->Database Utilities->Compact and Repair

I think when you delete tables and such from Access, they're still somewhere in the background, so you have to compact the db to get rid of them permanently.
May 1 '06 #2
thanks cweiss

this has reduced the db to 14.5Mb but will this eliminate the problem for good? (or will I have to wait to find out!!)

Thanks for your help though. If anyone else know anymore about this db size explosion please help!
May 1 '06 #3
cweiss
36
If you go to Tools-Options->General, there's an option to Compact on Close. If you check it, then you shouldn't have to worry about this problem in the future

To state the obvious, this will prevent your database from becoming bloated by compacting every time you close it :).
May 1 '06 #4
If you go to Tools-Options->General, there's an option to Compact on Close. If you check it, then you shouldn't have to worry about this problem in the future

To state the obvious, this will prevent your database from becoming bloated by compacting every time you close it :).
Thanks again. This will certainly work for the time being - I am putting the db onto a webserver (not my own) in the near future for users to access online - do you think this will cause any further size explosion problems (will your fix still work?)
May 1 '06 #5
cweiss
36
Hmm, I've never used access as a backend in web development so I can't say for sure, if it always compacts on close I would think you'll be okay.

From what I can tell, this is caused because when some object (like a table), or data in your database, is deleted, it's not really deleted, it still resides somewhere in the database. To completely eliminate it you have to compact and repair.

I suppose as long as your users aren't deleting tables or data often, you shouldn't have to worry about it too much.

Worst case, you'll need to compact and repair it periodically.
May 1 '06 #6
wlc04
70
Access will always increase in size when it's used. By checking the compact on close option it will keep the size in check for you.
May 3 '06 #7

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

Similar topics

1
by: NOSPAM | last post by:
Hello, I am hoping you can help me with the following problem; I need to process the following steps every couple of hours in order to keep our Sql 2000 database a small as possible (the...
2
by: Tim Chmielewski | last post by:
I have a an Access 2000 database that I have given read & write permissions to the IUSR & IWAM users on my machine (for a web application), but every time I open the database directly, it loses the...
5
by: Karl | last post by:
Hi C# experts, I am to C# and .NET. I am writing a database application using C# and Dataset. In Sql server, I have a Acount table which contains over 100,000 records. This table will be...
3
by: Tony Lugg | last post by:
I have an application with a document management form. When users add documents to the form, I call the API function SHGetFileInfo to get the associated large and small icons for the file. These...
4
by: cover | last post by:
I have two distinctively different pieces of equipment that I'm trying to build a database for, each having 20 inputs which makes my mysql table 40 fields wide. Form one is for 'shakers' and...
12
by: Jozef | last post by:
Here's a strange one. I made a modification to a database recently, and wound up getting an error message when trying to make an mde file. I'm using Access XP/2002, and the error message I got...
1
by: tricard | last post by:
Good afternoon all, I have recently been trying my hand out at the ADO model as before I have only used DAO (just thought I would expand my knowledge a bit). The problem I am having is that...
30
by: Neil | last post by:
Yikes! My database, which had been consistently 1 gig for a long time, went from being 1 gig to 3 gigs overnight! Looking at the nightly backups, the database increased on average about 5-15 MB per...
3
by: Xean45 | last post by:
Hey all, Sorry to be the noob with two posts asking a question, but I've been fighting with this for a couple days now, and as far as I can tell, this should be working, but PHP isn't my main...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.