Only want to insert a record

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.

Dave


.

Relevant Pages