I have an access database that links to a ProvideX database.
TableA is the linked table.
TableB is my table in access.
I want to read the data in TableA and add records to TableB that do not exist in TableA. But I would like this to happen automatically. Not necessarily by clicking a button.
Any suggestion or help to proceed would be greatly appreciated.
