And I've never seen any MM recommendation pertaining to CF and Access MDB file size. Hummm.
--- Ben -----Original Message----- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 4:22 PM To: CF-Talk Subject: Re: MS Access to large at 25MB? Didn't see this before....but I'm guessing you're on Intermedia? I've recently had to change hosts because of this seemingly arbitrary "rule" they put on their new Win2003 accounts. I know my DB shouldn't be on Access, but there's no reason that I have seen as to why it shouldn't work. Has been for 4 years now. We don't have the time to make huge changes to the four sites that are using Access right now, nor does the client want to pay for such a move. As they shouldn't. I really hate to dog on a host in a public forum, but they flat out refuse to make any adjustments, and I don't remember MM ever saying that M$ Access databases have to be under 7MB. Why hasn't any other host ever imposed this limit? Again, I'm not excusing the use of Access DB's, they shouldn't be used, but some "legacy" applications do, and they shouldn't have to be changes because some host wants to squeeze in a few more sites on one server. My 2 pence, Ray Joelle Tegwen wrote: > I'm going to say they're right. We've got a database at 29MB and we've > been dogging for a while. (We're migrating to MySQL). Maybe it's > partially an architecture issue, maybe it's a volume issue? I don't > know, but we've had this problem with Access and ASP (I can't imagine > CF is that different) Joelle > > I Rz wrote: > >> I received the following email from our hosting company. I have never >> heard of this before. Has any one? They actually disabled our account >> based on this. >> At work I am running one access database with 750MB (I know, but...) >> without any issues. They are claiming that it is using too much CPU >> resources and causing "CF ISSUES". >> Thanks. >> >> Hello , >> Our level two engineers have reviewed your database >> (xxxx.mdb) which now stands at 19.5MB which is too large. Our System >> Administrators have requested that you please reduce your database >> down to 7MB or less, based on the recommendations from Macromedia and >> Microsoft. In working with them to improve the stability and >> performance of our ColdFusion servers, they have informed us that MS >> Access databases over 7MB cause the majority of the issue we see, and >> Macromedia will no longer assist us in troubleshooting issues when >> the size is large then 7MB. If you cannot compact the database, we >> would ask that you move this database to MS SQL, where large >> databases will not cause performance issues for other users on your >> shared server. >> >> >> __________________________________________________ >> Do You Yahoo!? >> Tired of spam? Yahoo! Mail has the best spam protection around >> http://mail.yahoo.com >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231996 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
