Troble with a pass through query

[itm]

Hi,

I have an Access 2007 database that I have inherited, and in there are pass through queries that connect to SQL Server tables. Now I see that in the ODBC set up of the queries, are set up with trusted windows connection. I know I only have Read rights on the production server that these queries connect to. On a form that they have it takes the results of this query and uses it as DAO record set to populate an excel sheet. However, when I make a change to the query, I am just adding a field in the select statement, and when I run this from the form; it stops at the creation of the record set and says something to the extent that the field can be from multiple tables and that it is not sure which. When I go back to the query the code changes that I made are gone. That is, the join to a table that I had to make to bring in this filed and the field in the select statement is gone. Now, before running it on the form the query displays the results and is okay. So why does this happen? Is this because I do not have rights? But would it actually erase my code changes in the pass through query?

Thank you

[Stingaway]

Try copying the query first, then creating a new query based on the original. As for the field being from multiple tables, specify the table name in the query along with the field and you should be okay.

[itm]

Thanks I will try this.