Re: Replicating a Secured & Split Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Overway (paul_at_I.hate.spam.logico-solutions.com)
Date: 01/27/05


Date: Thu, 27 Jan 2005 14:05:45 -0500

Yes...it is safe to replicate a split, secure database. You should be
replicating the data file (back end) and not your application (front end)
though. Basically, you need to follow the advice in Security FAQs....then
implement replication following the replication white paper.

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;190766

-- 
Paul Overway
Logico Solutions
http://www.logico-solutions.com
"Pattyt" <Pattyt@discussions.microsoft.com> wrote in message 
news:1F532025-0482-437E-977F-0DE593201AB1@microsoft.com...
> Hello,
> I am in the process of securing an existing database with user-level
> security and additionally this database will be split.  My question is, is 
> it
> safe to replicate a split db that also has  User-level security and if so
> what is the process to do so? I have never come accross this matter and I
> want to know what I am doing before I make any mistakes.
>
> Thank You 


Relevant Pages

  • Re: on-line and near-line databases
    ... 'B' database) and only keep users from the last 30 days in the ... data restoration approach. ... Copy the records in the subscriber database which are to be ... ready and we 'replicate the execution of the ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication for Access
    ... I imported the tables, forms, queries, reports, and modules into and new ... database and regenerated the tables and links to create a new unreplicated ... When I try to replicate the data file it keeps saying the file is all ready ...
    (microsoft.public.access.replication)
  • Re: How to get an unix programmer started on web programming?
    ... part of my job is to identify possible risks and inform my customers of them. ... But you incorrectly assumed the security requirements are not at all necessary. ... that's a major problem with the database. ... is to replicate ONLY THE REQUIRED DATA. ...
    (comp.lang.php)
  • Selective Replication
    ... Have two schemas in the same database. ... used for currents an A_HIST is used to capture ... Using Triggers on 20 tables in A to replicate ... and have flexibility of possibly have the A_HIST schema in a different ...
    (comp.databases.oracle.server)
  • Re: Replicas
    ... The undocumented first rule with Access Replication: Only Replicate Tables. ... In my systems I have two database front ends that they can open. ... standard one for data maintenance, standard reports, etc and a personal play ... temporary and customised tables, queries, reports, etc. ...
    (microsoft.public.access.replication)