J
June
I have a very, very strange problem. I have an updateable
query with a one-to-one relationship between 2 tables.
When I view the query, I can update the fields.
If I view the SQL, highlight the SQL, and press Cntl+C to
copy the text, and then look at the query results again,
the query is no longer updateable.
The only way I can correct this is to view the query in
Design view, delete the joins, and reconnect the joins.
The query becomes updateable once again.
Is something corrupt? Is something wrong with my query?
I have forms based on this query and I don't want them to
become randomly un-updateable for the users.
Thanks in advance,
June
query with a one-to-one relationship between 2 tables.
When I view the query, I can update the fields.
If I view the SQL, highlight the SQL, and press Cntl+C to
copy the text, and then look at the query results again,
the query is no longer updateable.
The only way I can correct this is to view the query in
Design view, delete the joins, and reconnect the joins.
The query becomes updateable once again.
Is something corrupt? Is something wrong with my query?
I have forms based on this query and I don't want them to
become randomly un-updateable for the users.
Thanks in advance,
June