just right click on the database file you copied over. make sure the web client or what ever your server calls it has read/write privileges to the db.
that's it. -paul -----Original Message----- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 2:44 PM To: CF-Talk Subject: RE: weird insert/update error I am receiving the same error message after migrating an app from my laptop (wok, CIF, Silk) to our dev box (same). Can you tell me what permissions needed to be reset/set? All seems to be in order. (I have also checked, per earlier comment, both MAC versions and they are the same (2.6). did this help you at all?) -Craig Thomas -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:23 PM To: CF-Talk Subject: RE: weird insert/update error found the problem.... when i copied the files & the data base to the server, the file permissions where reset. i had to allow web users to be able to write to the database. kind of odd, never ran into this before. should be fine now. -paul -----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:50 AM To: CF-Talk Subject: RE: weird insert/update error no. download the MDAC checker from MS (http://www.microsoft.com/mdac) and run it at the server console. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:27 AM To: CF-Talk Subject: RE: weird insert/update error ok. can i do that in cf admin? -paul -----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:06 AM To: CF-Talk Subject: RE: weird insert/update error check the MDAC version on the production box. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:31 AM To: CF-Talk Subject: weird insert/update error ok i have this little app. runs just fine on my local host using cf 5.0 server it also runs just fine on our cf 4.51 production server winNT but when i move it to a 5.0 production server that is win2k i get the error below same files, same db, same odbc's... any ideas. thanks -paul 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 (10:1) to (10:26). ______________________________________________________________________ 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 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