>When I converted a Access 2.0 application to Access 97, the update to a query did not work. It work in Access 2.0. Here is the line of code:
>
>UPDATE DISTINCTROW qryCCBuild01 INNER JOIN tmpcomp
>
>The qryCCBuild01 is a query and tmpcomp is a temp table.
>
>The error message that I get is "Can not make to query.
>
>Have anyone run into this problem? How did you get around it?
>
>Thank
>
>Marc
Is that your entire query? It seems to me that you're missing your join condition, such as "ON qryCCBuild01.Code = tmpcomp.Code"
Hugo Dahl
"My get up and go must've got up and went"
-Steve Tyler, Aerosmith