JOINED update queries use a very odd syntax in Access. Best thing to do is use Access' Design Query mode to get the query you want, then look at the SQL version.
> > <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 > ______________________________________________________________________ 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
