Bruce, Rodney S HQISEC/Veridian IT Services wrote: > I had a similar issue, but quite as bad, but an MS access db would grow to > 2GB in about a week or less depending on the activity.
You might want to check if your client variables have "global updates" enabled, they can add quite a bit of load. > I solved (if you call it that) the issue by doing an automatice compression > of the db everynight. > > Let me know and I will email you the code off list. > > I got the origanal code from Jochem, so he might have a more updated version > as well. I received some patches (for password protected databases), but haven't gotten around testing them yet. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137404 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
