M mcnewsxp Sep 12, 2006 #1 if a query contains 1 or more joins is it true that the rows are not editable? tia, mcnewxp
J John Spencer Sep 12, 2006 #2 No, that is not true in Access. A query with multiple tables can be updatable. It depends on how the query is set up, what fields are included, the table structure, etc.
No, that is not true in Access. A query with multiple tables can be updatable. It depends on how the query is set up, what fields are included, the table structure, etc.
M mcnewsxp Sep 12, 2006 #3 No, that is not true in Access. A query with multiple tables can be updatable. It depends on how the query is set up, what fields are included, the table structure, etc. Click to expand... please elaborate...
No, that is not true in Access. A query with multiple tables can be updatable. It depends on how the query is set up, what fields are included, the table structure, etc. Click to expand... please elaborate...
I Immanuel Sibero Sep 12, 2006 #4 mcnewsxp, This is covered in Access help file (A2K). In the answer wizard, type in: update data from a query? from the resultant topics, select the third: When can I update data from a query HTH, Immanuel Sibero
mcnewsxp, This is covered in Access help file (A2K). In the answer wizard, type in: update data from a query? from the resultant topics, select the third: When can I update data from a query HTH, Immanuel Sibero
M mcnewsxp Sep 12, 2006 #5 mcnewsxp, This is covered in Access help file (A2K). In the answer wizard, type in: update data from a query? from the resultant topics, select the third: When can I update data from a query Click to expand... i think i figured it out. i needed primary keys and had some bad duplicate data in one of the tables. thanks, mc
mcnewsxp, This is covered in Access help file (A2K). In the answer wizard, type in: update data from a query? from the resultant topics, select the third: When can I update data from a query Click to expand... i think i figured it out. i needed primary keys and had some bad duplicate data in one of the tables. thanks, mc
