Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

synchronise 2 databases

Status
Not open for further replies.
anneoctaaf

anneoctaaf

Programmer
Dec 15, 2003
104
0
0
NL
There are 2 databases, both with the same tables. One database is fysically somewhere else and once in awhile both databases need to be updated with added/updated records from the other database. I guess one can call it synchronisation. But it goes both ways. Is there a simple way to do this?

Just as an example i will show the product table.
PRODUCTS
product_id
Product_name
Product_price

This table is in both databases. Both databases can be filled with new data. When i synchronise, both databases need to be filled with the new records from the other database!

Thanx!
 
Sort by date Sort by votes
Access and SQL Server both have replication. Have you looked this up? This is designed to manage disconnected distributed databases.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
115
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
209
TheresAlwaysAWay
TheresAlwaysAWay
leifoet
  • Locked
  • Question
SQL query with UNION ALL of 2 tables does not work
Replies
7
Views
84
Andrzejek
Andrzejek
PWD
  • Locked
  • Question
Access 2019 IIF + Public Function 1
Replies
5
Views
52
PWD
PWD
PWD
  • Locked
  • Question
Access 2010 Financial/Fiscal Year
Replies
4
Views
113
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top