Re: FE/BE Replication Question

On Sat, 31 Dec 2005 08:53:02 -0800, Debbie
<Debbie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>All 3 of their servers are physically in the same location, in fact they are
>next to each other. The remote locations have 1 or 2 PCs that that users
>share. There are 3-4 users per location each with their own logon id and
>password.

OK - since the servers are in the same physical location, then they
are on the same LAN, and direct synchronization is appropriate between
them.

>
>The client had opted to use replication because they wanted each of the 12
>locations to view only their data. They sychronize at the end of each day.
>They do hide the design master and synchronize to a replica. There are 12
>copies of the database spread over the 3 servers.

Have you considered using a single server, with a single database,
using Read With Owners Permission (RWOP) queries to restrict the
records that each user is allowed to see? It might be a simpler and
cleaner configuration than using multiple servers with partial
replication between them. RWOP queries are explained somewhat in the
Security FAQ -- see the website in my signature for a link if you
don't have it already.


>
>The central office wanted to report on the data for all locations. You
>mentioned they should not be doing replication. What are the risks in doing
>so? Thank you both SO MUCH for this valuable information.

I think that I said doing direct synchronization over a WAN can lead
to database corruption. That's not your situation since the servers
are in a single physical location. Doing direct synchronization over a
WAN is problematic because both replicas involved in the sync need to
be opened simultaneously and WAN connectivity can be sporatic. A
dropped connection can corrupt the database.



>Debbie
>
>"Debbie" wrote:
>
>> Hello all,
>> My client has an old Access application where all objects including tables
>> are in one database. They are also using replication whereas they have a
>> design master on the server and several locations have partial replicas which
>> are stored on the server, all clients are thin clients. They also are using
>> user level security. That all works fine.
>>
>> Now, I have re-written the application and in doing so have split the
>> database and continued to use user level security. That's all fine.
>> However, we are unsure about how to use replication in this design scenario.
>> The design parameters are:
>> - the design master and replicas are stored on the server.
>> - All the locations must have partial replicas containing only their data.
>>
>> I have the following questions:
>> 1. In this scenario, I can create partial replicas on the backend database.
>> However, should I create replicas for the front end database for each
>> location? Can you create a replica of a front end containing all objects
>> except tables? I have tried this and I got an error message. I think I need
>> to because the application is written in ADO and there are provider
>> statements with a hard coded path statement that points to the back end
>> database.
>> 2. Is there a way to synchronize a back end database from the front end?
>> In the old application since all object were in the same database, it wasn't
>> an issue.
>>
>> Thanks so much, I did download the Replication FAQ paper but nothing seems
>> to address this particular scenario. Any ideas are appreciated. Thanks so
>> much,
>> Debbie

**********************
jackmacMACdonald@xxxxxxxxxxxxxx
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
.

Relevant Pages

  • Re: FE/BE Replication Question
    ... >>All 3 of their servers are physically in the same location, ... > are on the same LAN, and direct synchronization is appropriate between ... >>The client had opted to use replication because they wanted each of the 12 ... >>copies of the database spread over the 3 servers. ...
    (microsoft.public.access.replication)
  • Re: MySQL Clustering
    ... The following solves replication breaking over the same auto int race ... Prior to inserting anything into this database, ... mysql> select * from users; ... the user has a random chance of hitting any of your database servers ...
    (freebsd-isp)
  • Re: FE/BE Replication Question
    ... >Thank you so much - I will definately investigate RWOP queries. ... >>>All 3 of their servers are physically in the same location, ... >>>The client had opted to use replication because they wanted each of the 12 ... >>>copies of the database spread over the 3 servers. ...
    (microsoft.public.access.replication)
  • Re: Replication***Please Help***
    ... with different security levels access the database at the same time. ... database at one time without using replication, ... In the design master all of the links are working fine, ...
    (microsoft.public.access.replication)
  • Re: AC97 - Replica
    ... Replication is (next to ... Assuming this is the Design Master that is now messed up, ... read up on the topic of Recover Design Master. ... I'm traying chaging a mdb database in Access 97. ...
    (microsoft.public.access.security)