Ozair
Adding to John's response...
Front ends tend to gradually get a lot of fragmentation not only where data is concerned but also with the code, forms and reports. This happens as you create or modify objects.
What I do is make a copy of the front end and then decompile the copy (Instructions here: www.fmsinc.com/microsoftaccess/performance/decompile.asp ). After decompiling and compacting you should see a significant reduction in file size.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <ozairkhalid@hotmail.com> wrote:
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
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar