Edit Data Access Page

[Guest]

I am working in Access 2000. I have 8 related tables and a query for the
same. I have a data access page that I would like to be read-write, but the
only fields that are read-write are those from Table 1. The other 7 tables
can be read but not updated. I have gone through the settings and tried to
see what is different between the tables but I haven't been able to figure it
out. Does anyone have suggestions for something I could try? Thank you in
advance.

 

[Douglas J Steele]

Do you have a Primary Key defined for all 7 of the tables in question? I
suspect you've only got one on the table that's updatable.

 

[Guest]

Thank you for your suggestion and quick response, I checked and all 8 of the
tables have primary keys. Is there anything else that I should check?

Thank you again for your time,

 

[Douglas J Steele]

Are you trying to update the tables one at a time, or through a join?

If through a join, it may well be that the query isn't updatable.

 

[Guest]

I tried to make the data access page based on a query, but when I did that,
nothing was updatable. This is how I would prefer to run the dap, but I'm
not sure how to change the query so that it is updatable.

Currently I have the dap updated through individual tables. It is by this
method that I can only update data from one table.

How do I change the query?