Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a flower store where we use MS Access and a client program to work with the database. But this program can work only with one database. We are going to open a new store, so now we have to solve the problem of syncing between the two databases. It can be synced once a day.

Is this possible with MS Access 2007 tools, or we have to buy some program?

share|improve this question
It is possible to do this, but it will require VBA & SQL, how much will depend on how many tables and what kind of differences. Some notes… – Remou Aug 29 '12 at 13:55
If you use Access 2010 and sharepoint, everyone can share the same database. – user11308 Sep 2 '12 at 19:00
We don't use sharepouint. is it free? – Max Sep 3 '12 at 7:03
Microsoft Access supports a feature called Replication that may do what you want. See for more information. Replication keeps databases synchronized so changes made in any database is replicated to the other databases involved. – Max Vernon Sep 26 '12 at 5:32
up vote 2 down vote accepted

You can use the import data tools that are part of access to import data from one database into the other. It is under the "External Data" tab. This should work as long as you have network access to both databases.

Some more info :

Before doing this, have a little think about your table design - do you need to have a flag to indicate which store the data came from? If the data is normalized, you may have have issues importing data that may be resolved by the order that the data is imported in.

Also, remember to regularly backup these database files before trying to import. This way if you break something you can go back and start again. Also store them on physically different disks just in case....

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.