Operation must use an updateable query

  • Thread starter Thread starter Adrian Leontovich
  • Start date Start date
A

Adrian Leontovich

I know when using ASP to post to Access via web form, this error usually
means that there is some rights issue associated with the table. Since I"ve
upgraded to Access 2002 however, I"m not sure anymore where or how I would
make this modification. I can see the Security options for this given DB,
but have no idea hwo to read it or change things to free up the rights I
need for the server to be able to make the posts. Has anyone run into
this???
 
I know when using ASP to post to Access via web form, this error usually
means that there is some rights issue associated with the table.
Click to expand...

Much more commonly, in Access anyway, it means that... you must use an
updateable Query. Not all queries can be updated, though many can.

Some common issues:

- A two (or multi-) table query must have a unique Index on the
joining field of the "one" side table, and a nonunique index on the
joining field in the "many" side.

- No TOTALS query, nor any query including a Totals query, can be
updated.

- UNION queries, queries with the DISTINCT (or synonymously Unique
Values) property, crosstab queries, and a variety of other query types
are not updateable.

If it's not obvious what's blocking updating, please open the Query in
SQL view and post the SQL code here.
 
Back
Top