Link to home
Start Free TrialLog in
Avatar of myndwire
myndwire

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Yossarian-22
Yossarian-22

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.
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.
<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.
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).
<Who would ever let users access the desktop of the main enterprise DC anyways?>

I agree with that ...