• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 455
  • Last Modified:

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?
0
myndwire
Asked:
myndwire
  • 3
  • 3
1 Solution
 
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
 
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
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now