Ms Access replication alternative

I have a fairly large ms access database that we use at our main office and sevral remote offices. Currently we useremote desktop at  the remote offices to access it, but its rather slow. I have domain controllers at each site and was looking for a speedier solution. I read up about replication but have found that most say its hard to get working and even harder to maintain. I was wondering if there were any solutions like a nightly batch update from each remote office back to the main office server where the backend tables are stored. The remoteoffices are small and it would be acceptable to wait until after business hours to push the current day's data back to the main office. Any suggestions?
myndwireAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You could do something like this, but it's basically home-built replication, and you'd still have all the issues associated with replication (data conflicts, corruption, etc).

You could move your datastore to a SQL Server, MySQL etc etc, which allows remote access, and then modify your application to use this platform. This can look to be a fairly simple move at first glance, but it can be somewhat difficult to achieve if you're not comfortable with server-based hardware/software, and simply moving your data store to a server can often result in poorer performance.

If you want to maintain your database as-is, the simplest way to do this is through Terminal Server. If you're running SBS, then you already have Terminal Server (it's part of the Server CD), but you would need to purchase Termainal Server licenses for this. Using TS, you can host the database at one location, and remote users can fire off their TS connection and work with the database just as they do now on Remote Desktop, but with (generally) a significant increase in performance. Of course, TS comes with maintenance issues (although most TS installs, once setup correctly, are pretty low maintenance) and you'd have to either beef up an existing machine, or setup a new machine to run your TS. Note there are alternatives to TS (http://www.thinsoftinc.com/support_winconxp.aspx is one)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Yossarian-22Commented:
SBS does not allow a terminal server installation.

For keeping it really simple get a dedicated server with Windows 2003 Standard, join your domain, install Citrix Access Essentials and let the remote workers enjoy Citrix SSL-sessions.
This way there is no hassle about keeping different databases in sync and the performance should be quite as good as running it locally.
0
Yossarian-22Commented:
You might as well try this tool:

http://dbconvert.com/convert-access-to-mssql-sync.php

It should allow synchronisation of MS Access data between Access databases without utilizing the internal replication process of Access. It comes with a scheduler as well.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<SBS does not allow a terminal server installation.>

I was under the impression that 2008 does include Terminal Server. I run 2003, along with a separate TS box on the network.
0
Yossarian-22Commented:
Here you go regarding terminal services in SBS 2008:

http://blogs.technet.com/sbs/archive/2008/09/26/can-i-use-terminal-services-in-sbs-2008.aspx

Who would ever let users access the desktop of the main enterprise DC anyways? As the article behind the above mentioned link states, that the Premium version of SBS 2008 comes with an additional Windows 2008 standard edition which would allow the setup of terminal services.

But having experience with both, terminal services on Win 2008 and Citrix, I would strongly recommend a Citrix Access Essentials installation in this case. It's small, easily manageble and the clients have easy access (especially via the SSL-gateway).
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<Who would ever let users access the desktop of the main enterprise DC anyways?>

I agree with that ...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.