Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Splitting a database & permissions

Discussion in 'Information Technology' started by Secret Squirrel, Jul 28, 2006.

  1. Secret Squirrel

    Secret Squirrel
    Expand Collapse
    Guest

    I split my secure database into a BE/FE but now I lose all my permissions to
    my tables. Is this normal or am I doing something wrong?
     
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    I shouldn't think so
    My way has however always been

    Sub FixRights
    Dim Ws AS DAO.WorkSpace
    Dim CDb AS DAO.Database, BeDb AS DAO.Database
    Dim CCont AS DAO.Container, BECont AS DAO.Container
    Dim CDoc AS DAO.Document, BEDoc As DAO.Document
    Dim Grp AS DAO.Group ' Assume rights assigned to groups - not users

    On Error Resume Next ' No Error handling

    Set Ws = Access.DbEngine.Workspaces(0)
    Set Cdb = Access.CurrentDb()
    Set BEDb = Access.OpenDatabase("BackEnd") ' Substitute..................
    For Each CCont In Cdb.Containers
    Set BECont = BEDb.Containers(CCont.Name)
    For Each CDoc In CCont.Document
    Set BEDoc = BECont.Documents(CDoc.Name)
    For Each Grp In Ws.Groups
    CDoc.UserName = Grp.Name
    BEDoc.UserName = CDoc.UserName
    CDoc.Permissions = BEDoc.Permissions
    Next
    Next
    Next
    ' Clean up Objects here ..

    End Sub

    Pieter

    "Secret Squirrel" <secretsquirrel@discussions.microsoft.com> wrote in
    message news:BDD1BD6A-C381-439E-8AD1-1A3020B20AB9@microsoft.com...
    >I split my secure database into a BE/FE but now I lose all my permissions
    >to
    > my tables. Is this normal or am I doing something wrong?
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    I shouldn't think so
    My way has however always been

    Sub FixRights
    Dim Ws AS DAO.WorkSpace
    Dim CDb AS DAO.Database, BeDb AS DAO.Database
    Dim CCont AS DAO.Container, BECont AS DAO.Container
    Dim CDoc AS DAO.Document, BEDoc As DAO.Document
    Dim Grp AS DAO.Group ' Assume rights assigned to groups - not users

    On Error Resume Next ' No Error handling

    Set Ws = Access.DbEngine.Workspaces(0)
    Set Cdb = Access.CurrentDb()
    Set BEDb = Access.OpenDatabase("BackEnd") ' Substitute..................
    For Each CCont In Cdb.Containers
    Set BECont = BEDb.Containers(CCont.Name)
    For Each CDoc In CCont.Document
    Set BEDoc = BECont.Documents(CDoc.Name)
    For Each Grp In Ws.Groups
    CDoc.UserName = Grp.Name
    BEDoc.UserName = CDoc.UserName
    CDoc.Permissions = BEDoc.Permissions
    Next
    Next
    Next
    ' Clean up Objects here ..

    End Sub

    Pieter

    "Secret Squirrel" <secretsquirrel@discussions.microsoft.com> wrote in
    message news:BDD1BD6A-C381-439E-8AD1-1A3020B20AB9@microsoft.com...
    >I split my secure database into a BE/FE but now I lose all my permissions
    >to
    > my tables. Is this normal or am I doing something wrong?




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4231 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  5. Secret Squirrel

    Secret Squirrel
    Expand Collapse
    Guest

    And where do I put this code exactly?
    Why won't it copy the permissions over when I split the database? All I'm
    doing it copying and pasting my original database and then deleting
    everything but the tables and then linking them to the FE. Am I missing
    something here?

    "Pieter Wijnen" wrote:

    > I shouldn't think so
    > My way has however always been
    >
    > Sub FixRights
    > Dim Ws AS DAO.WorkSpace
    > Dim CDb AS DAO.Database, BeDb AS DAO.Database
    > Dim CCont AS DAO.Container, BECont AS DAO.Container
    > Dim CDoc AS DAO.Document, BEDoc As DAO.Document
    > Dim Grp AS DAO.Group ' Assume rights assigned to groups - not users
    >
    > On Error Resume Next ' No Error handling
    >
    > Set Ws = Access.DbEngine.Workspaces(0)
    > Set Cdb = Access.CurrentDb()
    > Set BEDb = Access.OpenDatabase("BackEnd") ' Substitute..................
    > For Each CCont In Cdb.Containers
    > Set BECont = BEDb.Containers(CCont.Name)
    > For Each CDoc In CCont.Document
    > Set BEDoc = BECont.Documents(CDoc.Name)
    > For Each Grp In Ws.Groups
    > CDoc.UserName = Grp.Name
    > BEDoc.UserName = CDoc.UserName
    > CDoc.Permissions = BEDoc.Permissions
    > Next
    > Next
    > Next
    > ' Clean up Objects here ..
    >
    > End Sub
    >
    > Pieter
    >
    > "Secret Squirrel" <secretsquirrel@discussions.microsoft.com> wrote in
    > message news:BDD1BD6A-C381-439E-8AD1-1A3020B20AB9@microsoft.com...
    > >I split my secure database into a BE/FE but now I lose all my permissions
    > >to
    > > my tables. Is this normal or am I doing something wrong?

    >
    >
    >
     
  6. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    in a new module
    place the cursor anywhere within the code & hit F5

    Pieter

    PS if you'd used the "db splitter" wizard it'd done it for you


    "Secret Squirrel" <secretsquirrel@discussions.microsoft.com> wrote in
    message news:7B5DD7C8-D7B4-4542-BB2B-90BF262D9828@microsoft.com...
    > And where do I put this code exactly?
    > Why won't it copy the permissions over when I split the database? All I'm
    > doing it copying and pasting my original database and then deleting
    > everything but the tables and then linking them to the FE. Am I missing
    > something here?
    >
    > "Pieter Wijnen" wrote:
    >
    >> I shouldn't think so
    >> My way has however always been
    >>
    >> Sub FixRights
    >> Dim Ws AS DAO.WorkSpace
    >> Dim CDb AS DAO.Database, BeDb AS DAO.Database
    >> Dim CCont AS DAO.Container, BECont AS DAO.Container
    >> Dim CDoc AS DAO.Document, BEDoc As DAO.Document
    >> Dim Grp AS DAO.Group ' Assume rights assigned to groups - not users
    >>
    >> On Error Resume Next ' No Error handling
    >>
    >> Set Ws = Access.DbEngine.Workspaces(0)
    >> Set Cdb = Access.CurrentDb()
    >> Set BEDb = Access.OpenDatabase("BackEnd") '
    >> Substitute..................
    >> For Each CCont In Cdb.Containers
    >> Set BECont = BEDb.Containers(CCont.Name)
    >> For Each CDoc In CCont.Document
    >> Set BEDoc = BECont.Documents(CDoc.Name)
    >> For Each Grp In Ws.Groups
    >> CDoc.UserName = Grp.Name
    >> BEDoc.UserName = CDoc.UserName
    >> CDoc.Permissions = BEDoc.Permissions
    >> Next
    >> Next
    >> Next
    >> ' Clean up Objects here ..
    >>
    >> End Sub
    >>
    >> Pieter
    >>
    >> "Secret Squirrel" <secretsquirrel@discussions.microsoft.com> wrote in
    >> message news:BDD1BD6A-C381-439E-8AD1-1A3020B20AB9@microsoft.com...
    >> >I split my secure database into a BE/FE but now I lose all my
    >> >permissions
    >> >to
    >> > my tables. Is this normal or am I doing something wrong?

    >>
    >>
    >>
     
  7. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    in a new module
    place the cursor anywhere within the code & hit F5

    Pieter

    PS if you'd used the "db splitter" wizard it'd done it for you


    "Secret Squirrel" <secretsquirrel@discussions.microsoft.com> wrote in
    message news:7B5DD7C8-D7B4-4542-BB2B-90BF262D9828@microsoft.com...
    > And where do I put this code exactly?
    > Why won't it copy the permissions over when I split the database? All I'm
    > doing it copying and pasting my original database and then deleting
    > everything but the tables and then linking them to the FE. Am I missing
    > something here?
    >
    > "Pieter Wijnen" wrote:
    >
    >> I shouldn't think so
    >> My way has however always been
    >>
    >> Sub FixRights
    >> Dim Ws AS DAO.WorkSpace
    >> Dim CDb AS DAO.Database, BeDb AS DAO.Database
    >> Dim CCont AS DAO.Container, BECont AS DAO.Container
    >> Dim CDoc AS DAO.Document, BEDoc As DAO.Document
    >> Dim Grp AS DAO.Group ' Assume rights assigned to groups - not users
    >>
    >> On Error Resume Next ' No Error handling
    >>
    >> Set Ws = Access.DbEngine.Workspaces(0)
    >> Set Cdb = Access.CurrentDb()
    >> Set BEDb = Access.OpenDatabase("BackEnd") '
    >> Substitute..................
    >> For Each CCont In Cdb.Containers
    >> Set BECont = BEDb.Containers(CCont.Name)
    >> For Each CDoc In CCont.Document
    >> Set BEDoc = BECont.Documents(CDoc.Name)
    >> For Each Grp In Ws.Groups
    >> CDoc.UserName = Grp.Name
    >> BEDoc.UserName = CDoc.UserName
    >> CDoc.Permissions = BEDoc.Permissions
    >> Next
    >> Next
    >> Next
    >> ' Clean up Objects here ..
    >>
    >> End Sub
    >>
    >> Pieter
    >>
    >> "Secret Squirrel" <secretsquirrel@discussions.microsoft.com> wrote in
    >> message news:BDD1BD6A-C381-439E-8AD1-1A3020B20AB9@microsoft.com...
    >> >I split my secure database into a BE/FE but now I lose all my
    >> >permissions
    >> >to
    >> > my tables. Is this normal or am I doing something wrong?

    >>
    >>
    >>




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4231 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  8. Joan Wild

    Joan Wild
    Expand Collapse
    Guest

    If you used the splitter wizard to split the secure mdb, then yes that is
    normal.

    Don't use the wizard to split it. If you have a backup of the original, you
    can split it manually.

    Otherwise, you'll have to join your secure mdw and resecure the backend.


    --
    Joan Wild
    Microsoft Access MVP

    Secret Squirrel wrote:
    > I split my secure database into a BE/FE but now I lose all my
    > permissions to my tables. Is this normal or am I doing something
    > wrong?
     

Share This Page