I think this is a rights issue. What are the rights on your Access DB? I had this error one when the user that IIS was running under did not have rights to edit the Access DB.
That is why it is telling you that you "must use an updateable query" HTH, -- Josh Trefethen .:::::[ Exciteworks, Inc ]::[ http://exciteworks.com ]:::::. .::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::. > -----Original Message----- > From: Jim Kraft [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2003 7:00 AM > To: CF-Talk > Subject: Insert and update ? For new CF server > > > I have been using cold Fusion 3.X for years and just upgraded > to a server with the latest version. All of my queries > worked fine on the old version but now I get this error > message on my insert. Is there something I need to do with > the code or is it in the server. Thanks for any assistance. > > > Error Executing Database Query. > > [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC > Microsoft Access Driver] Operation must use an updateable query. > > The Error Occurred in D:\wwwroot\Kraft\Qtr Report > 2003\InsertQR2003.cfm: line 14 > > 12 : <body bgcolor="FFFFFF"> > 13 : <img src="../images2/banner.JPG" width="700" height="114"> > 14 : <CFINSERT DATASOURCE="QtrReport2003" TableName="2003QR"> > 15 : > 16 : <CFQUERY NAME="GetEnteredRecordID" DATASOURCE="QtrReport2003"> > > -------------------------------------------------------------- > -------------- > ---- > > SQL insert into 2003QR (NAME,PASSWORD) values ( (param 1) , > (param 2) ) > DATASOURCE QtrReport2003 > VENDORERRORCODE -3035 > SQLSTATE HY000 > > It also will run the update pages it gives the following > error message. > > Error Executing Database Query. > > [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC > Microsoft Access Driver] Operation must use an updateable query. > > The Error Occurred in D:\wwwroot\Kraft\Qtr Report > 2003\UpdateQR2003.cfm: line 14 > > 12 : <body bgcolor="FFFFFF"> > 13 : <img src="../images2/banner.JPG" width="700" height="114"> > 14 : <CFUpdate DATASOURCE="QtrReport2003" TableName="2003QR"> > 15 : > 16 : <CFQUERY NAME="GetUpdate" DATASOURCE="QtrReport2003"> > -------------------------------------------------------------- > -------------- > ---- > SQL update 2003QR set ACTUALHOURS1= (param 1) ,BRANDING1= (param 2) > ,NOTINBUS1= (param > > DATASOURCE QtrReport2003 > VENDORERRORCODE -3035 > SQLSTATE HY000 > > Jim Kraft, Director > Region 8 SBDC > 33 South 3rd St. > Richmond, IN 47374 > 765-962-2887 fax 765-966-0882 > [EMAIL PROTECTED] http://www.sbdc1.org > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
