Eddie,
After reading bithead's link, look at #3. Maybe the ODBC data source
settings for "feedback" in the CF Administrator has restricted SQL options
checked. Take a look there.
Thanks,
Joe Kelly
[EMAIL PROTECTED]
972-242-9989
----- Original Message -----
From: "Bithead Basic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 12:47 PM
Subject: Re: Simple Access Insert
> Heya Eddie (and list)!
>
> Take a look at the following link...
>
> http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
>
> Hopefully, one of the fixes in this article will help you out...
>
> --bithead101
>
> --- "Phillips, Eddie" <[EMAIL PROTECTED]> wrote:
> > 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
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
>
> -------------------------------------------------------------------------
> 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
