Re: Only want to insert a record


"Daniel Crichton" <msnews@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23ULG0EeFGHA.2444@xxxxxxxxxxxxxxxxxxxxxxx
>
> "Dave" <dave5398@xxxxxxxxxxxxxx> wrote in message
> news:eOuM54dFGHA.3892@xxxxxxxxxxxxxxxxxxxxxxx
>> I'm trying again to develop my web application locally using IIS and asp
>> scripting with a local MS Access database. I have never managed to
>> update or insert a record using scripting. I can seem to display records
>> ok but any attempt to amend records seems to fail. I tried using
>> recordsets then read in MS documentation you should execute a direct
>> command. My latest failed attempt is this:
>>
>> ConnectionString = ".....etc"
>> Conn.Mode=3
>> Conn.Open(ConnectionString)
>> sql="INSERT INTO Users (Name, Password) VALUES ('Jim', 'Hello')"
>> Conn.Execute sql
>>
>> The sql works fine within Access itself. When executed within an asp page
>> however I get:
>>
>> Error Type:
>> Microsoft JET Database Engine (0x80004005)
>> Operation must use an updateable query.
>>
>> Can anyone please help, I've been trying for months.
>
> Do you have a primary key on that table? The error message suggests not.
> Also try adding [] around your table and column names - in some system
> Name and Password are reserved words, and ADO or the OLE DB driver may be
> trying to interpret them as such. Also drop the Mode property, I've never
> needed to use this myself as I believe the default is to not set any
> permissions, which lets you do whatever your user permissions allow.
>
> sql="INSERT INTO [Users] ([Name], [Password]) VALUES ('Jim', 'Hello')"
>
>
> Dan

Dan,

Thanks but still no look. I did all of the above and still get the same
result. Any reason why calling ADO from a script should be different to
calling it from MS Access or VB?

Dave



.

Relevant Pages