K
Kevin Myers
In MS Access 2000 I am developing a form for editing and viewing the
combined data from half a dozen tables. When I include all but one of the
tables in the source query for the form, everything is fine and I can edit
all of the desired fields. However, when I include the last table the query
suddenly appears to become read-only, and I can no longer edit fields from
any of the tables.
The join criteria for this last table are different from the others as
follows:
1) A left outer join must be used when adding this final table because it
does not include rows corresponding to some of the rows in the other tables,
and all of the rows from the other tables are required in the result set.
2) The join criteria for the last table involves comparing a couple of its
columns to substrings of a column in one of the other tables, i.e.:
where county.country_id=well.country.id and
county.state_api=mid(well.api,1,2) and county.county_api=mid(well.api,3,3)
Can anyone confirm whether one or both of the above ideosyncracies will
force a query to become read-only as the source for a form?
Can anyone point me to some documentation that describes the exact
circumstances under which a query will become read-only as the source for a
form?
Finally, assuming that one of the above issues does in fact force the source
query to become read only, can anyone suggest a reasonable work-around?
Please note that the database structure is supplied by a third party, and
cannot be changed. All I can do is change the the form or its source query.
Note that the only reason for joining to this particular table is to
*display* the value of a single column from that table. This particular
value does *not* need to be edited. However, I am very new at Access form
development, and haven't yet figured out any way that I can display the
column values from this last table on the form without including that table
in my source query, and thus hitting the apparant read-only query problem.
Thanks in advance for any help.
s/KAM
combined data from half a dozen tables. When I include all but one of the
tables in the source query for the form, everything is fine and I can edit
all of the desired fields. However, when I include the last table the query
suddenly appears to become read-only, and I can no longer edit fields from
any of the tables.
The join criteria for this last table are different from the others as
follows:
1) A left outer join must be used when adding this final table because it
does not include rows corresponding to some of the rows in the other tables,
and all of the rows from the other tables are required in the result set.
2) The join criteria for the last table involves comparing a couple of its
columns to substrings of a column in one of the other tables, i.e.:
where county.country_id=well.country.id and
county.state_api=mid(well.api,1,2) and county.county_api=mid(well.api,3,3)
Can anyone confirm whether one or both of the above ideosyncracies will
force a query to become read-only as the source for a form?
Can anyone point me to some documentation that describes the exact
circumstances under which a query will become read-only as the source for a
form?
Finally, assuming that one of the above issues does in fact force the source
query to become read only, can anyone suggest a reasonable work-around?
Please note that the database structure is supplied by a third party, and
cannot be changed. All I can do is change the the form or its source query.
Note that the only reason for joining to this particular table is to
*display* the value of a single column from that table. This particular
value does *not* need to be edited. However, I am very new at Access form
development, and haven't yet figured out any way that I can display the
column values from this last table on the form without including that table
in my source query, and thus hitting the apparant read-only query problem.
Thanks in advance for any help.
s/KAM