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.
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. -----Original Message----- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB I just got back from a client site and they are running CF5 and MS access. The problem is that the MSAccess file grows at least 5 MB per min. thus filling the hard disk. I was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137400 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
