Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    6

    Unanswered: 4 tables in a query

    I have a query for a subform that has 2 intersection entities and 2 look up tables. For some reason the query does not let me make any changes. In the status bar it doesn't say that it is locked for editing.

    When I change the recordset type to : Dynaset (Inconsistent Updates) I am able to make changes, however the correct data is not displaying.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    And your question is???
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2007
    Posts
    6
    Why is it not editing? Access does allow multiple intersection entities to be used for data entry?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Nycbigapple
    Why is it not editing? Access does allow multiple intersection entities to be used for data entry?
    Most likely because your query does not uniquely identify each row in the recordset related back to the tables it's based upon ...

    Yes it does as long as you have the PKs (or another means of uniquely referencing the row in the table that selected data came from) for the recordset to update the underlying table(s).
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •