Thanx bithead101,
It was the first one - the IIS guest user did not have access. Also, thanx
to everyone else for their suggestions and research!
Eddie
-----Original Message-----
From: Bithead Basic [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 26, 2001 12:47 PM
To: [EMAIL PROTECTED]
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
