Split Your Database
Watch this video and see if this may work for you.

V/r
Juan

Juan I believe Justin already has his db split based on his post.  

What he is asking, is how to tie together multiple physical locations with out going down the online server route.
Right now they are using what I refer to as the Sneaker Net - They make copies of their data and "walk it" to the other machine to update each other. in other words, transfer the files via iDrive.
Justin did I get that right?

Justin check out the Access Online page.
It might be that you guys could get by with using a remote desktop.  I haven't
used Google's Chrome Remote Desktop but I do use a different one for supporting a remote site.
The down side is if you're needing printing, creating real time invoices etc.

Ah Ok I had the same where I wanted to keep all my data local.  I purchased a Synology NAS and plugged into the back of the router.  I have access to my database from all computers on my network.  Took awhile to set up but I think it's the way to go.

V/r
Juan

Yeah, you could set up something to do this along the lines of what I show in the Sync Remote Database video, however your best bet would be to move your backend data to an online SQL Server. I know you said you don't want another monthly fee but in all honesty you can get an account with WinHost for around $5 a month - less than a Starbucks venti latte. And if this is helping you with your work that's obviously a justifiable expense to be able to share data properly between the three of you. I wouldn't waste time or effort doing anything else.

Hello and thank you all for the great feedback. I should have joined up a year ago when I found your videos on youtube. I have lots of homework reviewing your great suggestions and look forward to updating on my progress going forward. I am sure there will be more questions. My db is based off the service contract management template provided with Access XP, yeah that old, with some scheduling and some other tracking. With the replication added it is close to 2 gigs. It has not been split yet but that is my next avenue to explore. Thanks again and have a great weekend  Justin

Using Winhost actually involves two sets of recurring fees: hosting fee paid to Winhost, and domain registration fee paid to the "registrar."  A registrar is a company like GoDaddy that sells domain names.  These are annual fees, not monthly.  You pay upfront every year.  Winhost charges $60/yr, and a registrar charges $10-20 a year.

If you don't want to pay recurring fees, you can install SQL Server on your own PC and make it publicly accessible on the Internet.  But managing and maintaining such a PC is a complicated matter.  I did that in my old job 20 years ago and it was like a second job.  That's why nowadays people pay hosting services like Winhost the $70-90 a year to avoid such headaches.

If you must use Access, there is an online service called Access Database Cloud that adds Internet connectivity (which Access doesn't have).  But the service has a heart-stoppingly high monthly fee:   https://www.accessdatabasecloud.com/pricing