All of a sudden my access database has started opening up in exclusive mode, although when I look at the options on it, its set by default to open in shared mode. I get an error in CF that it can not open 'unknown'. When I close the database some of my queries give me this error: Error Diagnostic Information ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (7:1) to (7:48). Any suggestions? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists