Solved

Syncronize data across databases

Posted on 2011-03-25
5
255 Views
Last Modified: 2012-06-27
Hello Everyone,
I need to deploy a MS Access Database in 3 different geographical areas, the database will be identical in all three sites. Only one of the 3 will be the Master database where data entry will take place, the other two will simply be used for reporting. What would be the best way to create a data sync between the master and the other 2 databases without a human intervention? Say for example the database will synchronize every time data is changes to the Master.

Thanks
0
Comment
Question by:joeserrone
  • 3
5 Comments
 
LVL 57
ID: 35214279

 I would have answered replication, but starting with A2007, it's been dropped from JET.  SQL Server still offers replication however.

 One question is; is it just new records that need to be synch'd up, or are you planning on deletes and edits as well.  If the latter, it really gets to be a chore.

Another thought; if users have internet connectivity at all times, you'd be far better to think about a remote access solution such as RDP/Citrix to handle this and forget about replication entirely.

JimD.
0
 

Author Comment

by:joeserrone
ID: 35214840
I'm only concerned about new records, there will be no edits or deletions. What do you think it would be the best solution by keeping it in Access?
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 35215243
<<I'm only concerned about new records, there will be no edits or deletions. What do you think it would be the best solution by keeping it in Access? >>

  That's simple enough then.  You can use a GUID for your primary keys so that every record is unique.  Then it's a simple merge into your "master" DB (that's basically how replication works).

  BTW, what version of Access are you planning to use?

JimD
0
 
LVL 10

Expert Comment

by:VTKegan
ID: 35215867
If these 3 different geographical locations all are on the same network, you can just use linked tables. I never saw you mention the requirement for offline use.  If everyone is connected to the network couldn't you used linked tables?
0
 
LVL 57
ID: 35215945
<<If everyone is connected to the network couldn't you used linked tables? >>

  Not over a WAN with a JET DB.  You need very fat pipes and decent routers for it to work.

JimD.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now