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 programmaticall y) 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!)
6 1645
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.
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!
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 :).
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?)
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.
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.
Sign in to post your reply or Sign up for a free account.
Similar topics |
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 transaction log is 5x bigger than the db).
1.back-up the entire database
2.truncate the log
3.shrink the log
4.back-up once again.
|
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 permissions for those
users.
Anyone know how this happens?
Thanks.
--
|
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
accessed and updated by many users at same time. So the data in this table
keeps changing and growning.
I want to keep each user's local Dataset updated every time he does a update
or does a query. My code is like this:
|
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 icons are
added to two ImageList objects which are bound to a ListView control,
and everything looks great. I am saving the icons to a SQL Server
table by using Icon.Save to a stream and assigning the byte array to
the field, then loading them...
|
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 form two is for 'conveyors'. About the
only thing they will have in common is that they both share
'motorsize' and they both share 'bearing' although shakers have two
where conveyors have four.
I'd first built a table within a database called...
| |
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 was "Microsoft Access was
unable to create an mde database". After researching the error and the
solutions, I've run the gamut of solutions (or comply with the requirements)
when I came across the "maximum table ids" issue which can cause this...
|
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 while I am executing and debugging
code, my database keeps getting put into a locked state and I cannot
seem to get it out of this state without closing MS Access and
reopening it (and this doesn't seem to always work either).
I used to have this...
|
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 day, and was 1.06 GB on the
Thursday night backup. Then, with the Friday night backup, it was 2.95 GB,
and has stayed that way since!
I did a Shrink on the database, but that didn't help the situation.
The only thing I could think it might...
|
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 language, so I'm sure there's something being missed.
I've made a small program that allows the user to first select a country, then a state/province, and finally add a city to that location. So, when a new city is submitted, I load the .TXT file...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |