Thanks Just tried the code on a seperate machine after compacting the database. Worked like breeze.
KR Srimanta ----- Original Message ----- From: Mike Brunt <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Sunday, February 02, 2003 5:11 PM Subject: RE: Slow Update > Can you post the code you are using. > > Kind Regards - Mike Brunt > Webapper Services LLC > Web Site http://www.webapper.com > Blog http://www.webapper.net > > Webapper <Web Application Specialists> > > -----Original Message----- > From: DESIGN SHOP [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 03, 2003 1:45 PM > To: CF-Talk > Subject: Slow Update > > Hello Forum, > > I am trying to update an access database using a CF template which is taking > ages for the job. No error is generated. > When I try to accomplish the same job within Access by running a Macro (SQL > Query) it takes less than half a minute for thesame job. Other CF pages with > queries run without any problem. > Any ideas what is happening? Where should I start looking. > > Regards, > > Srimanta > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4