Eddie,
Shot in the dark here.....
Would there some confusion caused because your DSN, table name, form field
name and column name are all the same - "feedback"?
----- Original Message -----
From: "Phillips, Eddie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 12:00 PM
Subject: Simple Access Insert
> Greetings All,
>
> I am coming across a strange error, that I am sure is the result of
> something simple. I have a simple form that is passing vales to a template
> that is inserting into an Access 2000 Database.
>
> Here is the cfquery code:
>
> <cfquery name="insert_rec" datasource="feedback">
> Insert into feedback (Name, request, requesttype, dept, approved,
feedback)
> Values ('#form.name#', '#form.request#', '#form.requesttype#',
> '#form.dept#', '#form.approved#', '#form.feedback#')
>
> </cfquery>
>
> The error I get is:
>
> ODBC Error Code = S1000 (General error)
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> query.
>
>
> The really strange thing is I copied the code into query analyzer,
replaced
> the cf variables with actual data and it works. I then took that exact
SQL
> line (including the data I put in) and put it between my cfquery tags,
> replacing the above and I still get the same error.
>
> Any suggestions would be greatly appreciated.
>
> Eddie
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
