I have a small problem that requires functionality like the following to be resolved. Users of an off-the-shelf product are updating three separate but like SQL Server databases in different subsidiaries and updates to a certain group of fields in a given table present in each of these three databases are supposed to be replicated to an Access database in real time.
Being a semi-professional Access programmer, I'm not sure how to approach this problem exactly. Whether I should try using the Timer event of an Access form that keeps checking for insertions. I think this can solve the problem but I'm unsure about performance issues.
The other way to do this as I have heard is by setting up a Windows service. I am also not sure how to go about doing this if this is "the" solution.
I am not sure which is better or if there are ways even better than these two.
I appreciate your help.