[AccessD] A2K3 Bloating

Jim DeMarco Jdemarco at hudsonhealthplan.org
Fri Nov 5 08:01:28 CST 2004


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".
***********************************************************************************




More information about the AccessD mailing list