the8thdove said:
why can't i enter data when i join three tables in a query that are
joined?
There is an entire help topic that covers this. Look for "when can I update
data in a query?". The reasons for any specific query will vary so you should
read the help topic first and if you still can't get it resolved then post back
and include the SQL for your query.
Basically in a muti-table query the complexity and structure can get to a point
where Access (Jet) has trouble determining which table should be updated. When
that line is crossed the query becomes read only as a means to prevent mangling
the data with an incorrect update.
Access/Jet is actually one of the most forgiving database engines in this
regard. Many database engines absolutely never allow a query/view with a join
in it to be updateable. Those that do have specific rules that must be adhered
to otherwise the result is read only.
