HELP! > Operation must use an...

Hi,



i dont know what is happening but i cant update or delete or
insert records in my access database, this error appears:



Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver]

Operation must use an updateable query.





i already talked to my web administrators and they said
already give me all permissions, when i run locally that site on my
local machine runs perfectly i can upload and insert all good, but
one its in the server that bloody error appears,:



So Please!!, i need help on this one, i been trying to
figuring what is wrong for days,, thank you..



check this link try to insert to see the problem




http://att.atentiusa.com/request/req.cfm







and this is my query i using on that page:



%26lt;cfset
CurrentPage=GetFileFromPath(GetBaseTemplatePath())%26gt;

%26lt;cfif IsDefined(''FORM.MM_InsertRecord'') AND
FORM.MM_InsertRecord EQ ''form1''%26gt;

%26lt;cfquery datasource=''#Request.DSN#''%26gt;

INSERT INTO RequestSpots (SpotName, TypeID, ''Description'',
DateRequest, AddressID)

VALUES (%26lt;cfif IsDefined(''FORM.SpotName'') AND
#FORM.SpotName# NEQ ''''%26gt;



%26lt;cfqueryparam value=''#FORM.SpotName#''
cfsqltype=''cf_sql_clob'' maxlength=''150''%26gt;

%26lt;cfelse%26gt;

''

%26lt;/cfif%26gt;

, %26lt;cfif IsDefined(''FORM.TypeID'') AND #FORM.TypeID# NEQ
''''%26gt;

%26lt;cfqueryparam value=''#FORM.TypeID#''
cfsqltype=''cf_sql_numeric''%26gt;

%26lt;cfelse%26gt;

NULL

%26lt;/cfif%26gt;

, %26lt;cfif IsDefined(''FORM.Description'') AND
#FORM.Description# NEQ ''''%26gt;

%26lt;cfqueryparam value=''#FORM.Description#''
cfsqltype=''cf_sql_clob'' maxlength=''1073741823''%26gt;

%26lt;cfelse%26gt;

''

%26lt;/cfif%26gt;

, %26lt;cfif IsDefined(''FORM.DateRequest'') AND
#FORM.DateRequest# NEQ ''''%26gt;

%26lt;cfqueryparam value=''#FORM.DateRequest#''
cfsqltype=''cf_sql_timestamp''%26gt;

%26lt;cfelse%26gt;

NULL

%26lt;/cfif%26gt;

, %26lt;cfif IsDefined(''FORM.AddressID'') AND #FORM.AddressID#
NEQ ''''%26gt;

%26lt;cfqueryparam value=''#FORM.AddressID#''
cfsqltype=''cf_sql_numeric''%26gt;

%26lt;cfelse%26gt;

NULL

%26lt;/cfif%26gt;

)

%26lt;/cfquery%26gt;

%26lt;cflocation url=''/upload/upload.cfm''%26gt;

%26lt;/cfif%26gt;

%26lt;cfquery name=''rsSpotTpe'' datasource=''#Request.DSN#''%26gt;

SELECT TypeID, TypeName

FROM SpotTypes

%26lt;/cfquery%26gt;

%26lt;cfquery name=''rsAddresses'' datasource=''#Request.DSN#''%26gt;

SELECT AddressID, Address

FROM Addresses

%26lt;/cfquery%26gt;

%26lt;title%26gt;Atenti - Reel%26lt;/title%26gt;

%26lt;cfinclude template=''/includes/head.cfm''%26gt;

%26lt;style type=''text/css''%26gt;

%26lt;!--

.style2 {color: #FFFFFF}

.style3 {

color: #FF3300;

font-weight: bold;

}

--%26gt;

%26lt;/style%26gt;

%26lt;/head%26gt;

%26lt;body%26gt;

%26lt;cfinclude template=''/includes/navigation.cfm''%26gt;

%26lt;tr%26gt;

%26lt;td id=''tdContent''%26gt;%26lt;h1%26gt;Request New
Spots%26lt;/h1%26gt;

%26lt;p%26gt; %26lt;/p%26gt;



%26lt;form method=''post'' enctype=''multipart/form-data''
name=''form1''
action=''%26lt;cfoutput%26gt;#CurrentPage#%26lt;/cfoutput%26gt;''%26gt;







%26lt;table align=''center''%26gt;

%26lt;tr valign=''baseline''%26gt;

%26lt;td nowrap align=''right''%26gt;Spot Name:%26lt;/td%26gt;

%26lt;td%26gt;%26lt;input type=''text'' name=''SpotName'' value=''''
size=''32''%26gt;%26lt;/td%26gt;

%26lt;/tr%26gt;

%26lt;tr valign=''baseline''%26gt;

%26lt;td nowrap align=''right''%26gt;Screen Type:%26lt;/td%26gt;

%26lt;td%26gt;%26lt;select name=''TypeID''%26gt;

%26lt;cfoutput query=''rsSpotTpe''%26gt;

%26lt;option
value=''#rsSpotTpe.TypeID#''%26gt;#rsSpotTpe.TypeName#%26lt;/option%26gt;

%26lt;/cfoutput%26gt;

%26lt;/select%26gt;

%26lt;/td%26gt;

%26lt;tr%26gt;

%26lt;tr valign=''baseline''%26gt;

%26lt;td nowrap align=''right''
valign=''top''%26gt;Description:%26lt;/td%26gt;

%26lt;td%26gt;%26lt;textarea name=''Description'' cols=''50''
rows=''5''%26gt;%26lt;/textarea%26gt;

%26lt;/td%26gt;

%26lt;/tr%26gt;

%26lt;tr valign=''baseline''%26gt;

%26lt;td nowrap align=''right''%26gt;Date Request:%26lt;/td%26gt;

%26lt;td%26gt;%26lt;input type=''text'' name=''DateRequest''
value=''%26lt;cfoutput%26gt;#LSDateFormat(Now())#%26lt;/cfoutput%26gt;''
size=''32''%26gt;%26lt;/td%26gt;

%26lt;/tr%26gt;

%26lt;tr valign=''baseline''%26gt;

%26lt;td nowrap align=''right''%26gt;Address:%26lt;/td%26gt;

%26lt;td%26gt;%26lt;select name=''AddressID''%26gt;

%26lt;cfoutput query=''rsAddresses''%26gt;

%26lt;option
value=''#rsAddresses.AddressID#''%26gt;#rsAddresses.Address#%26lt;/option%26gt;

%26lt;/cfoutput%26gt;

%26lt;/select%26gt;

%26lt;/td%26gt;

%26lt;tr%26gt;

%26lt;tr valign=''baseline''%26gt;

%26lt;td nowrap align=''right''%26gt; %26lt;/td%26gt;

%26lt;td%26gt;%26lt;input type=''submit'' value=''Save and
Send''%26gt;%26lt;/td%26gt;



%26lt;/tr%26gt;

%26lt;/table%26gt;

%26lt;input type=''hidden'' name=''MM_InsertRecord''
value=''form1''%26gt;

%26lt;/form%26gt;



%26lt;p%26gt; %26lt;/p%26gt;

%26lt;p%26gt; %26lt;/p%26gt;

%26lt;p%26gt; %26lt;/p%26gt;%26lt;/td%26gt; %26lt;td
id=''tdSidebar''%26gt; %26lt;/td%26gt;

%26lt;/tr%26gt;

%26lt;cfinclude template=''/includes/footer.cfm''%26gt;

%26lt;/body%26gt;

%26lt;/html%26gt;

HELP! %26gt; Operation must use an...
Try this workaround:


http://support.microsoft.com/kb/830977



ThanksHELP! %26gt; Operation must use an...
Hi,



This TechNote from Adobe works too!.




http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_17282%26amp;sliceId=2
Have you tried a JDBC connector instead of using ODBC?
First ensure you use the correct syntax



INSERT INTO RequestSpots (SpotName, TypeID, ''Description'',
DateRequest, AddressID)



Should be



INSERT INTO RequestSpots (SpotName, TypeID, [Description],
DateRequest, AddressID)



Second

What data type have you set the description and spotName
field to be ? The code would indicate Memo (from memory just use
varchar)



Third

Ensure that the columns can be set to NULL where you have
this option.



Ken