Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
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 '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 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. –  Max Vernon Sep 26 '12 at 5:32
add comment

1 Answer

up vote 1 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 : 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....

share|improve this answer
add comment

Your Answer

 
discard

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.