I have an Access 2000 database , where one of the tables (Table X) is updated from another Access database table(TableY). When changes are made in the source database (Table Y) , I only want to update certain fields in Table X and keep the other fields the same.
How can this be done?