> 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."
I don't use Access enough to know whether you can use a subquery in an UPDATE statement, but I've seen that error message before when the Access database file was marked as read-only on the filesystem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
