7

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?

4
  • 2
    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 stackoverflow.com/questions/1903912/…
    – Remou
    Aug 29, 2012 at 13:55
  • If you use Access 2010 and sharepoint, everyone can share the same database.
    – user11308
    Sep 2, 2012 at 19:00
  • We don't use sharepouint. is it free?
    – Max
    Sep 3, 2012 at 7:03
  • Microsoft Access supports a feature called Replication that may do what you want. See duckduckgo.com/?q=microsoft+access+replication for more information. Replication keeps databases synchronized so changes made in any database is replicated to the other databases involved.
    – Hannah Vernon
    Sep 26, 2012 at 5:32

1 Answer 1

2

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 : http://office.microsoft.com/en-us/access-help/import-or-link-to-data-in-another-access-database-HA001227658.aspx

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....

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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