Acc ess VBA synchronize two tables
Hi
I have two Access tables (Table1 and Table2) of the same structure in two different offices.
Each month I need to "synchronize" the data so that they each have all the information. So I need all the records in Table1 that aren't in Table2 to be added to Table2 and all the records from Table2 that aren't in Table1 to be added to Table1.
How wouls I do this? What techniques would I use?
I have two Access tables (Table1 and Table2) of the same structure in two different offices.
Each month I need to "synchronize" the data so that they each have all the information. So I need all the records in Table1 that aren't in Table2 to be added to Table2 and all the records from Table2 that aren't in Table1 to be added to Table1.
How wouls I do this? What techniques would I use?
Last Comment
Sheils
Are the two computer on the same network. If yes then the best approach would be to split your database into backend and front end. Say backend on a central location and install frontend on each computer. No synchronizing required.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
