I get this error only on the new workstations...
It has been working on 25+ computers for years.... it is not working with new computer, which has Access 2003.
Surprisingly enough, another PC, which was upgraded to MS Access 2003 doesn't have that error.
First i thought it could be a user account or permissions issue.. but i have checked with an admin account on the new PC and it throws this error:
Error 3079: The specified field 'Product Code' could refer to more than one table listen in the FROM clause of your SQL statement
p.s. i have tried reinstalling access 2003