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