Access query from ASP error

[Darren_T]

Hi,

I'm working on a low traffic shopping cart and am using Access for the back end. I can query the database but when I try to perform an insert it gives me an error saying "must use an updateable query". I looked this up and it says it is due to perforiming aggregate functions. I'm not doing any of that. I'm using the same connection string for all my queries also. I'm not used to working with Access as I mostly develop for SQL server. Could this be a permissions problem? System not able to write or something?

Oh, almost forgot. I can perform the insert from the query designer in SQL view just fine and it updates the table. I just can't do the exact same insert from my ASP page.

Any help would be great. I can supply the database or code if needed.

Thanks!

Darren

 

[jfgambit]

Can you post the SQL of the Query so we could look at it?

 

[Darren_T]

Can you post the SQL of the Query so we could look at it?

It is a very simple insert. Here it is:

INSERT INTO customers (cfirstname) VALUES ('darren')

There are many more columns and values but they are all as simple as this one here. I've tried both queries in the query builder and they work fine, it seems to be related to my connection string possibly:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("admin/cart.mdb")

Thanks for any help you can provide.

Darren