*RESOLVED* Unable to update/insert/delete queries

[cjqp]

I'm trying to insert data to an Access 97 database via SQL (in ASP) and I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

For updating and deleting I get errors much like that one.
This all makes me think that for some reasons my database thinks it is read only. I have checked the database file and it doesn't seem to be read only at all. I have also created another database with same results.

My code is:

[CODE]
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ= " & server.mappath("stats.mdb"))
Set oRS = oConn.Execute("INSERT INTO Stats VALUES('test', 'test', 'test', 'test', 'test')")
Set oRS = Nothing
Set oConn = Nothing

Set oConn = Server.CreateObject

My database is attatched.

cjqp

[Mongo]

HTH: http://forums.devshed.com/t65143/scd...5cd39277f.html

[cjqp]

Thank you for pointing me in the right direction!

cjqp