• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Mirroring Access Databases Across Multiple Sites in real time

T

TechBoyJK

Lifer
Can anybody tell me how to approach mirroring access database sites, one in Canada and one in US? Each site will be the mirror of the other, and a load balancing setup will balance traffice between the two sites. However, how do I get the Access databases to stay mirrored in real time?
 
I'm assuming you're using MSDE as an engine? If so, you can actually use SQLServer management tools with it, and I believe use the Replication Wizards.

 
The thought that occurs to me is that if it's absolutely necessary to have them mirrored in real time, you might be better off in having one site query the other and forget the mirrored databases. That could be less overhead than the synchronization, unless you are doing large queries.

How often is the database changing? How much data are you querying at a time?
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top