query problem

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi!
I use ASP to access the contents of an Access DB.Up till now my application
was workinf fine.
However, I decide to do some changes. So I copy all the files I use in
another directory and I changed the fields of my db.
Now, whenever I try to insert a new record or update an existing one I get
the following msg:
"Operation must use an updateable query"
I tried some simple queries for example to enter a new record with only the
key, but still doesn't work :-(

Any ideas?
Thnx in advance
 
Now, whenever I try to insert a new record or update an existing one I get
the following msg:
"Operation must use an updateable query"
I tried some simple queries for example to enter a new record with only the
key, but still doesn't work :-(
Click to expand...

Certain queries are updateable, and others are not. Could you open the
query that you're trying to update in SQL view and post the SQL text
here? Someone may be able to spot the problem. I suspect you've joined
another table without having a unique index on the joining field, or
perhaps you have included a Totals operation (such as Count or Sum) in
the query - either of these will block updating.
 
in my experience, queries are updatable only when the
underlying tables are linked by primary to foreign
fields. check the fields that are used to link tables,
see if primary to foreign is the problem.
 
Back
Top