Hello,

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.

Depending on where the Access db is located, some other options amy be to use triggers in SQL server to push the data to Access, or you might even just link the SQL tables directly to the Access db.

Matt