Query non-updateable when composite key field used.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:
My form wouldn't let me update, then I realize that my query is not updateable
either.
The properties are set to "Dynaset" and the other restrictions are set
correctly to allow updates.

I have two tables that contain two fields each. These fields are the
composite key of each table. When these field are added to the query, the
query becomes non-updateable. When they are removed, the query is updateable.

What is the reason for this? How could I make it an updateable query, but a?
 
Please post details of your Tables, specify the PKs from each Table and the
SQL String of the Query that you want to update from.
 

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

Similar Threads

not in query for composite key 2
Update primary key field with multiple "where" clauses 0
Update query that is updating fields not included in any statement 4
Updating a field that is a part of the composite primary key 1
Dynaset, inconsistent updates 20
DSum update query with multiple fields 0
Trying to update multiple fields in the same record (same table) 2
Update Query Help *urgent* 0

Back
Top