make sure the category table you're updating has the update priveledge checked.
----- Original Message ----- From: "Dale Fontenot" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 7:03 PM Subject: RE: SQL GURUS? > If I remember correctly the problem is a privilege problem. Check the > privileges on the folder the mdb resides in. > > -----Original Message----- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 03, 2002 10:36 AM > To: CF-Talk > Subject: Re: SQL GURUS? > > > Ahhhh the Access days. I remember that error...but for the life of me I > can't remember what the issue was (but it took me a while to figure it out). > > my useless 2 cents...sorry ;-( > > Bryan Stevenson > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > p. 250.920.8830 > e. [EMAIL PROTECTED] > --------------------------------------------------------- > Allaire Alliance Partner > www.allaire.com > > ----- Original Message ----- > From: "Kris Pilles" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, January 03, 2002 6:31 AM > Subject: SQL GURUS? > > > > I am having trouble with a query: > > > > Works fine in Oracle... > > > > <cfquery name="addtypes" datasource="kriskart"> > > Update category > > set tutorial = (Select max(section.tutorial) > > from section, category > > where category.code = section.catalogid) > > </cfquery> > > > > > > Anyidea why Access tells me this is an "[Microsoft][ODBC Microsoft Access > > Driver] Operation must use an updateable query." > > > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
