It still becomes a problem because it is not designed to handle large amounts of a data. I have worked at many places over the past 13 years that were in the process of moving to MySQL/MSSql/Oracle from Access because the site was so bogged down by the database after it hits about 60% capacity. Even through the jet engine, there are still locks and you do run into issues.
-----Original Message----- From: Claude Schnéegans <[email protected]> [mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans <schneegans@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Monday, May 30, 2011 09:12 AM To: cf-talk Subject: Re: Cannot install CF 9 >> I would suggest to avoid using Access anyway, it can be the cause stability issues on CF I know I know, This is true for multi user Access applications, programmed inside the Acces database. The problem must be in the way locks are managed in VBscript. As far as CF is concerned, this is pure urban legend: there is only one user: CF, and VBscript is out of the way. Only the jet engine is used. I've been using Access databases since 1995 and I've never ever seen any problem with them. Beside, Access databases have a few advantages. I'd me more interested knowing how you can get 64 bit CF work with 32 bit ODBC drivers. ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344993 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
