Re: FN-FORUM: Calling all ASP experts

date posted 29th June 2003 17:25

> INSERT INTO
>
tbl_Orders(product_id,customer_id,unit_price,price_paid,quantity,date_ordere
> d,order_status) VALUES(69,1,'30',30,10,'6/29/2003 10:49:56 AM','Ordered')

> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> query.

Is the product_id the primary key? Could be you are trying to insert a
record where the primary key is already in use?

Jon