wierd ODBC error.. 1

[Extras]

Am using CFMX on both my local machine and the production server. Both are on W2K-IIS

Have successfully run this code (pretty close to) 100s of times as I tested the site out. But when I loaded the site on the production server, I got hit with the error below, suspect this might have something to do with the settings on my production server, look forward to your assistance!

[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

The Error Occurred in C:\

http://www.nwc.cc.wy.us\Intranet\admin.cfm:

line 57

55 :AND
56 :StaffList.Staff_ACode='#form.Staff_ACode#'
57 : </CFQUERY>
58 : <CFLOCK SCOPE=&quot;APPLICATION&quot; TYPE=&quot;READONLY&quot; TIMEOUT=&quot;5&quot;>
59 : <CFSET variables.LocalEntryPoint=application.EntryPoint>


------------------------------------------------------------


The CF-code around that area is:

<CFQUERY NAME=&quot;UpdLogin&quot; DATASOURCE=&quot;#request.SiteDSN#&quot;>
UPDATE StaffList
SET StaffList.Staff_LastLogin = #CreateODBCDateTime(Now())#
WHERE StaffList.Staff_UserName='#form.Staff_UserName#'
AND StaffList.Staff_ACode='#form.Staff_ACode#'
</CFQUERY>
<CFLOCK SCOPE=&quot;APPLICATION&quot; TYPE=&quot;READONLY&quot; TIMEOUT=&quot;5&quot;>
<CFSET variables.LocalEntryPoint=application.EntryPoint>
</CFLOCK>

 

[tleish]

Check the Read/Write permissions on the file and/or folder of the db Access file.

For more info see:
'Operation Must Use an Updateable Query' Error

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q175168

- tleish

 

[Extras]

Thanks - that sounds like the most likely problem. Likely because I am not admin on the web server. Will forward the link to out tech staff and see what they come up with.

Thanks again for your prompt suggestion.

 

[Extras]

Worked like a charm - thanks!

#AA#