Hello everyone
I have two MS access databases. Each one is updated by using a specific interfaces (the first through the built-in MS access forms while the second through a specific interface)
Some tables need to be synchronized between those databases which means, for example, if there is any update (add/delete or update) on a table in the first database, the corresponding table on the second database must be updated. What solution/technology would you used to face this problem?
Here are what I tried to do…
1. Using linked tables & update them by a data macro (I’ve never used data macro before) >> problem: data macros can’t be used over a linked table (moreover I didn’t like them as they are so limited)
2. Using VBA to log all the transition into an external log file. Update each database using this file periodically >> problem: I wasn’t able to log the transaction directly from a table (data macro don’t allow vba) which means that for the second database I won’t be able to log anything (instead the first one which I do by my vba code into the forms)
I sincerely appreciate your consideration of this issue.