Access 2007 Multiple Data Table Query with Collect Data

[crew11k]

I have a database in Access 2007 with 3 data tables and 2 relational tables. I have a query that joins the data tables which I would like to use create an email, collect data, and update the results in the underlying data tables.

I set up a Simple Query using the Wizard. After chosing the fields from the three data tables, I view the query in design mode. I can see that Access has figured out the relationships between the three data tables and indicates that the relational tables in betwen. After running the query, I select "Create email" and an error message prompt displays:

"XXXX Query is read-only. You cannot use e-mail messages to collect or update data on this object"

I think the issue is that using the query on multiple data tables somehow makes the query read-only, but not sure how to fix this.

Any thoughts would be much appreciated.

 

[boblarson]

You need to make sure that the query is updatable. Here are some reasons which can make a query NON updatable:
http://allenbrowne.com/ser-61.html