I have an access db that has a few linked tables to a db2database. I made a local copy one of the linked tables.
Is there a way to have the local copy update with the db2 linked table is changed?
This is a work around for a problem we are having trying to connect MAS 90 to and ERP system using db2. Mas can not see the linked tables in access but can see the local tables.
Trying to see if there is any trigger that will update the local table.