Operation must use an updateable query

  • Thread starter Adrian Leontovich
  • 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???
 
J

John W. Vinson

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top