Access SQL Error

date posted 30th January 2001 16:02

Anybody got any idea what this means...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable query.

This is the result I am getting from a standard INSERT SQL query from an
ASP page - I have other databases on the same host, using the same code,
and they work fine. Could this be something to do with the configuration
of the database? This is really puzzling me...

All fields in the INSERT query exist in the table that I am inserting
into - I am specifying all of the fields, and the table definitely
exists. All data is in the correct format - I cannot see what I can
possibly be doing wrong. SELECT queries work fine, so I definitely have
a valid database connection. All permissions are turned on in Access, so
it's not a question of not being allowed write access to the table. The
table I am trying to insert into is empty, so there is definitely no
chance of duplicate records.

If it helps, here is the code that produces the above error:-
' Test Database
Set conn = Server.CreateObject("adodb.connection")
conn.Open "ShoppingCart", "myusername", "mypassword"
conn.Execute "insert into Countries (ID, CountryGroupID, Name) select
1, 1, 'USA';"
conn.Close
Well, this seems pretty perfect to me...

Although I know what the notion of an updatable query is in Access, I
was not aware that the fact that the query was updatable had to be
specified from within ASP, nor indeed how to specify that. So I am truly
stuck.

Any help greatly appreciated.

Mark