smonline,
Welcome to Amazing Charts. In order to do this, you would need to run AC on one server in Office A and then access that database in Office B. There are a number of options, but generally the best option is via a VPN using good routers and/or firewalls.
There are literally tens of threads on this very subject, and you may wish to search for them.
BUT, I ALWAYS END UP SAYING, if you have to ask, then you would probably be better off hiring an IT consultant. There are a lot of variables: network topology, server and server software, firewalls (Cisco >>> Linksys or Netgear for VPN), bandwidth, QOS, etc. I don't know how to say it enough. I would hire a networking specialist, pay the $75 to $100 per hour and have it done correctly right out of the box.
