Jim DeMarco
Jdemarco at hudsonhealthplan.org
Fri Nov 5 08:56:43 CST 2004
Understood Erwin. But I've been hearing that the new file format will either not compact down at all or very little unlike previous versions. Jim D. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Erwin Craps - IT Helps Sent: Friday, November 05, 2004 9:24 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2K3 Bloating Please note that is is normal that a file is smaller after compacting. Don't forget after compacting your code needs to compile and store, but also queuries are compiled the first time they run. Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim DeMarco Sent: Friday, November 05, 2004 3:01 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2K3 Bloating Thanks Darren. Is this db you're compacting in 2002/2003 format or 2000? As I understand it a 2002/2003 format file would not compact down like that. Jim DeMarco -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK Sent: Wednesday, November 03, 2004 5:23 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] A2K3 Bloating Hi Jim I think the issue is still there - maybe lessened, but still there If you have access to the app perhaps try this... I get into the code area and compile it I have an icon Called DECOMPILE in the SendTo folder of AllUsers that points to C:\ProgramFiles\Microsoft Office\OfficeXX\MSACCESS.exe /decompile (Replace the path with your Access Path) Then I right click the dB or the db's shortcut icon and click SendTo and select DECOMPILE Then I get into the dB and Compact and repair it. I can get a 9 meg monster down to about 1.8 - 2 megs Do it every time I deliver a fresh version or app HTH See ya DD -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, 4 November 2004 7:44 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2K3 Bloating What file format are you using? Charlotte Foust -----Original Message----- From: Erwin Craps - IT Helps [mailto:Erwin.Craps at ithelps.be] Sent: Wednesday, November 03, 2004 12:25 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2K3 Bloating I use A2K3 for a while now, I believe I never experienced a, out of the ordinary, bloating in A2K3. Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim DeMarco Sent: Wednesday, November 03, 2004 8:02 PM To: AccessD (E-mail) Subject: [AccessD] A2K3 Bloating List, Has M$ addressed the database bloating issue in A2K3 I've read about on the list? We're in the process of converting our A97 apps to A2K3 and I'm trying to decide between A2K format or A2K3. Any suggestions? TIA, Jim DeMarco Director Application Development Hudson Health Plan Tarrytown, NY ************************************************************************ *********** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ************************************************************************ *********** -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ************************************************************************ *********** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ************************************************************************ *********** -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************