Updateable Query Error

[JackV]

I've established an ADO connection to an Access DB on my local machine. When I try to pass an INSERT INTO statement to the connection.execute method, the browser pops up with an error that says "Must use an updatable query".

This ASP code is in my global.asa file and I'm only trying to add 1 record. Any help on this would be greatly appreciated.

[JackV]

Thanks for the response. The Access DB was just for testing. It was gonna be scaled up to SQL Server. I gave up on the Access DB and just did it on SQL Server off of a DNS I created on my machine. It works now.

The reason I have an INSERT statement in my global.asa file, is for the record that I create, I need to save the ID field value into a session variable.