Hi Bruce,
Bruce Young wrote:
> Yes I'm repopulating the lot. I'd have to test it but wouldn't CF complain
> about you deleting (or renaming) the DB file?
It won't if you turn off Cold Fusion temporarily. I use a .cfm file that
essentially tries to open a non-existant table. This closes the connection to
the database so that I can rename or delete the database, and it opens the
connection automatically as soon as someone tries to access the database (on a
busy site this wouldn't work). You could also use the code you provided below
to turn off Cold Fusion and do a rename/delete and then turn it back on.
I'm keeping a note of the code as my method only works if you are changing the
whole database. Depending on how big your table gets, it might be faster to put
a rename/delete in the process that loads the data, as compacting can take
awhile on large datasets.
>
> Anyway we have now implemented the method that Kathy winkled out of her
> co-workers, that came from an Allaire forums discussion, as follows:
>
> > 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"
>
> It seems to have been working fine for the last week on three different
> servers.
>
> thanks
> Bruce
>
> ____________________________________________________________________
> --------------------------------------------------------------------
> 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.
> ---------------------------------------------------------------------
--
Making the Web Work for You (tm)
Susan Duncan ([EMAIL PROTECTED]) Voice: (613) 744-3283
Director, Internet Development Fax: (613) 744-1825
http://www.malico.com Toll Free: (877) WEB-PROS
http://www.OttawaWEB.COM
MALICO - Graphic Design and Internet Development
Founders: Ottawa-Hull Chapter-Int'l Webmasters Association
____________________________________________________________________
--------------------------------------------------------------------
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.
---------------------------------------------------------------------
