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

Paul Backhouse paul.backhouse at 2cs.com
Tue Mar 26 06:55:01 CST 2002


I would need to see what your queries are.


-----Original Message-----
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


--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !




More information about the thelist mailing list