Query non-updateable when composite key field used.

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?
 
V

Van T. Dinh

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

Updateable querie 2
non-updateable query with memo field 1
recordset not updateable 2
RecordsetNot Updateable 22
Updateable Query Problem 9
Updateable query 3
Non-updateable query issue 1
Non-updateable query issue 24

Top