Bloating is normal if you are actively changing structure in the database,
or the linked or local content changes a lot.
A warning: if the bloat gets too big, approaching 2G, the Access database
can get corrupted. While it is possible to recover it, there is
considerable effort and risk of failure involved.
While you can manually run "compact and repair" as you indicated, you could
also go to "Tools, Options" and select the "General" tab. On there you can
select "Compact on close". This will mean increased time each time you
close the file, but no worries about bloating.
If your back end is also Access, same applies there. SQL backend has other
ways to accomplish this.
Gary
Original email:
-----------------
From: ozairkhalid@hotmail.com
Date: 11 Nov 2013 22:01:56 -0800
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] MS Access 2003 bloating excessively
Hi,
My front end MDB file is bloating excessively ( specially) when re-linking
tables using Linked Table Manager.
After compacting, the normal size of the front end MDB is 100MB which goes
up to 1GB ( even more ) during the re-link.
Any idea how to prevent it?
OS : Windows 2008 R2 64Bit
Database : SQL Server 2012
Office : MS Office 2003 with SP3 ( including Hotfix for SP3)
Ozair
----------------------------------------------------------
mail2web.com – Enhanced email for the mobile individual based on Microsoft®
Exchange - http://link.mail2web.com/Personal/EnhancedEmail
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar