Can anyone tell me how I can really compress/compact my 17MB mdb file.
A link to any third party MS Access 2003 compactor would do.
I have about 3 tables
1st table( 20 entries)
2nd // (15 records)
3rd // ( 3 records)
I have about 5 queries and 10 forms
But I don't see any reason why my db file is this big.
Thanks
14 9327 @Jerry Maiapu
Have you tried within Access itself to click:
Tools->Database Functions->Compact and Repair?
(Menu names may be different, depending on language settings)
OR You Can Use This Code in Vba - CommandBars("Menu Bar").Controls ("Tools") & _
-
.Controls("Database utilities") & _
-
.Controls("Compact and repair database...").accDoDefaultAction
Best Regards ,
Ahmed Tharwat( Medo)
But I don't see any reason why my db file is this big.
The Reason : Every Time You Edit The mdb file This Encrease The mdb file size , So You Should Run The Compact & Repair The Data base After You Finish from Edit mdb. Best Regards ,
Ahmed Tharwat( Medo)
This procedure has been repeatedly been given as the cause of corruption, so you should always back up your database before running C & R!
For this reason, IMHO, the Compact on Close option should never be used!
Linq ;0)>
I am sorry I would have told you already. I used C&Repair tool in access many times but still no changes. Are there other ways of compact/compressing apart from C&R tool or removing images from forms. (FYI: I have only one image in the start up form).
Thanks
First off, this isn't really a "big" database!
Secondly, if the image is actually stored in the database, rather than simply being linked to, and this is pre-Access 2007, this is probably your problem.
Linq ;0)>
No it's a link image so I'll try and check the link.
Thanks
OldBirdman,the problem seem to persist even now would you you tell me how to use the tool you advised me to download (POST#70? I downloaded it. The untility tool requires us to load two mdb files which two mdb files is it referring to?
Thanks
If anyone can help do so.
Cheers..
OldBirdman,the problem seem to persist even now would you you tell me how to use the tool you advised me to download (POST#70? I downloaded it. The utility tool requires us to load two mdb files. Compact From (Source) and Compact into (Destination).Which two mdb files is it referring to?
Thanks
If anyone can help do so.
Cheers..
This utility creates a new file, leaving the old one unchanged. Therefore, you do not need to backup the file before attempting to compact. Source is the name of your database. Destination is the name you want for the compacted database.
After you test the compacted version, you can delete your original copy(Source) and rename the new(Destination) to the original name.
Although this is not a 'third party' compactor, I have found that it compacts to the smallest size possible, as compared with Access 'Compact and Repair Database...' Tool
The database after compacting has now increased somehow to 18,996 kb which is about 19meg. Really pissing me off. Is there any other way to compact the mdb file?
Thanks
The only other way I know of is to start with a blank database and import the objects from your current database.
If you do this in several steps, importing only a few objects at a time, you should be able to figure out which object(s) are causing the excessive size.
Thanks I'll do that and come to you later
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Riley DeWiley |
last post by:
I have a project that is using a Jet backend and having trouble with Jet's
tendency to bloat it's MDB file. I can compact it but it is a hassle. I am
considering switching to a Fox backend but have...
|
by: Bob Darlington |
last post by:
I have a repair and backup database routine which runs when a user closes
down my application.
It works fine in my development machine, but breaks on a client's at the
following line:
If...
|
by: SheldonMopes |
last post by:
Here is my situation:I have several Access database projects that all
keep their back-end data in a directory on a server. I would like to
have a small Access application that could open each .mdb...
|
by: jez123456 |
last post by:
Hi, I’ve written a c# program to compact certain msaccess databases. The way
this works is to compact say C:\test1.mdb to C:\temp.mdb, then delete
C:\test1.mdb and rename C:\temp.mdb as...
|
by: Oded Dror |
last post by:
Hi there,
I have a Guestbook.mdb file on my website and I would like to compact this
file by using Compact.aspx file with Button click
How do I do that ?
Thanks,
Oded Dror
Email:...
|
by: Brian P. Hammer |
last post by:
All,
How do I go about compacting an Access XP database from VB code? I use a database for various reporting information and records are often deleted and created. The size of the database can...
|
by: Sher |
last post by:
Hi,
I have a project which requires having users upload files to be burnt to
compact disk. The requirement is to zip (compress) and/or span files to
compact disk size on upload. I cannot use...
|
by: Mark |
last post by:
Good evening all,
using a XP pro platform and Access 2003 SP2, is it possible to identify
a .zip file, inflate the file and then import the contents? I'm pretty
certain I could code steps 1 & 3...
|
by: teddysnips |
last post by:
My client has asked if it's possible to Compact and Repair his Front
End database programmatically. I remember doing this from a VB
application about 10 years ago, so I wondered if it was possible...
|
by: Bob Alston |
last post by:
I have a system built using Access replication. After some initial
problems dealing with memo fields, it now seems to be working well.
I am curious as to how frequently others Compress & Repair...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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,...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
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,...
| |