*RESOLVED* Unable to update/insert/delete queries

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

Code:

---

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

Code:

---

Set oConn = Server.CreateObject

---

My database is attatched.

cjqp

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

Thank you for pointing me in the right direction!

cjqp