Ozair-
During the relink, Access re-fetches the table definitions from the server. That may be what's causing the "bloat," and there's no way to avoid it other than to not require a relink every time.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ozairkhalid@hotmail.com
Sent: Tuesday, November 12, 2013 7:02 AM
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
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar