Hi Susan
>Are you repopulating all the tables in the database? If so, it might be
>easier to
>just replace the old version with a clean empty version instead of
>deleting the
>content and adding it again.
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?
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.
---------------------------------------------------------------------
