this is as close as I got as well...some other solution than runnig through
CF. Any other ideas or solutions welcome as I am on a project with a 100
field database with 6 supporting dbs....am sure I will run into this....and
I believe Jack was also interested in this??
Eric J Hoffman
Director of Internet Initiatives
Meagher & Geer, PLLP
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gill,
Kathy
Sent: Monday, November 09, 1998 3:10 PM
To: 'WC'
Subject: WC:>: FW: >: DB compaction
from one of my guru friends at boeing ...
> ----------
> From: Anderson, Jim D
> Sent: Monday, November 09, 1998 6:03 AM
>
>
> If Access is installed on the server, you could schedule a batch file with
> the AT scheduler.
>
> net stop "Cold Fusion Executive"
> net stop "Allaire Cold Fusion 3.1"
>
>
> c:\msoffice\access\msaccess.exe d:\yourdb.mdb /compact
>
>
> net start "Cold Fusion Executive"
> net start "Allaire Cold Fusion 3.1"
>
>
> For more info, see this thread:
> http://forums.allaire.com/DevConf/Thread.cfm?&&Message_ID=34696&_#Message3
> 4696
>
>
> Jim Anderson
>
> DCAC/MRM Webmaster
> 425-965-7046
>
>
>
> ----------
> From: Gill, Kathy[SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, November 08, 1998 7:34 PM
>
> -----------------------------------------------------
> anyone know the answer?
>
>
> > Kathy E. Gill
> > DCAC/MRM Production Visibility Support -- 425.234.2004, pager
> 425.568.0195
> > The biggest mistake people make in life is not trying to make a living
> at
> > doing what they most enjoy. ~ Malcomb S. Forbes
> > Microsoft Exchange: the perfect name for its users' greatest desire!
> >
> >
> > ----------
> > From: Bruce Young[SMTP:[EMAIL PROTECTED]]
> > Reply To: [EMAIL PROTECTED]
> > Sent: Sunday, November 08, 1998 3:09 PM
> > To: [EMAIL PROTECTED]
> > Subject: WC:>: DB compaction
> >
> > Hi
> >
> > I do a lot of DB work with Cold Fusion. One of the DB's is deleted and
> > repopulated each day from another source. I use the CF "transaction" tag
> > to
> > make sure that it completes everything properly before deleting the old
> > data.
> >
> > This is an MS Access DB on NT4 using CF. (please... beg... no Linux
> > references)
> >
> > However the DB has grown to 41Mb but when compacted is only 172kb! Is
> > there
> > anything I can do in a CF script or Perl to keep it in a more compact
> > form?
> > I don't want to change the basic system... I'm just after info on how to
> > keep the DB size under control automatically.
>
>
>
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
