[thelist] Updateable query? ASP DSN-less access connection

Edward George edward at suppose.co.uk
Tue Mar 26 06:40:01 CST 2002


I'm creating a dsn-less connection to an access database,
Everything works fine on our development server, but on the clients
server attempts to use the INSERT INTO or UPDATE sql queries generates
this error:


Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.


I'm connecting with...


set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
server.mappath("../database/******db.mdb")
Conn.Open


And using conn.Execute to execute the generated SQL string.
Writing out the SQL shows the SQL is formatted correctly.

Any ideas why it breaks like this?

Thanks.

Ed,
ed at suppose.co.uk





More information about the thelist mailing list