Welcome to SPN

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

Sign Up Now!

Upgrading BE database

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

  1. Len

    Len
    Expand Collapse
    Guest

    Hi,

    I am looking for references on how to upgrade BE database automatically by
    Admin user when:

    1.New fields has been added to BE tables or even new tables created
    2.The RWOP approach has been used in development. As a result Admin does not
    have any permissions on the BE tables

    Would appreciate any idea or direction.
     
  2. Loading...


  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Len" <Len@discussions.microsoft.com> wrote

    > I am looking for references on how to upgrade
    > BE database automatically by Admin user when:
    >
    > 1.New fields has been added to BE tables or even
    > new tables created
    > 2.The RWOP approach has been used in development.
    > As a result Admin does not have any permissions
    > on the BE tables


    Normal way to upgrade back-end is for the person with permission on the
    Tables to open a copy of the back-end directly (when no other users have
    access), make the modifications, regression test, and replace the production
    back-end. You must have permission on the tables in order to modify their
    design.

    For back-ends that exist in remote locations, sending the administrator of
    the location a database that includes code, queries, etc. that automates the
    changes is common. Still, the user must have permission to modify the table
    design.

    Larry Linson
    Microsoft Access MVP
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Or you could write code that connects to a new Workspace & Applies the
    changes through that
    that will offcourse only work if the Dbowner hasn't been removed from the
    ..mdw file the customers got

    something like

    Dim Db As DAO.Database
    Dim Ws As DAO.WorkSpace
    Dim TDef As DAO.TableDef
    Dim Fld AS DAO.Field

    Set Ws = DbEngine.CreateWorkspace("WS" & Timer(),"SuperUser","Secret")
    Set Db = Ws.OpenDatabase(CurrentDb()) ' Or Normally Path to Backend - which
    can be found quite easily through code

    On Error Resume next

    Set TDef = Nothing
    Set Tdef = Db.TableDefs("XXX")
    If TDef is Nothing Then
    ....... etc ....


    Pieter



    "Larry Linson" <bouncer@localhost.not> wrote in message
    news:%236wnZJAsGHA.596@TK2MSFTNGP04.phx.gbl...
    >
    > "Len" <Len@discussions.microsoft.com> wrote
    >
    > > I am looking for references on how to upgrade
    > > BE database automatically by Admin user when:
    > >
    > > 1.New fields has been added to BE tables or even
    > > new tables created
    > > 2.The RWOP approach has been used in development.
    > > As a result Admin does not have any permissions
    > > on the BE tables

    >
    > Normal way to upgrade back-end is for the person with permission on the
    > Tables to open a copy of the back-end directly (when no other users have
    > access), make the modifications, regression test, and replace the
    > production back-end. You must have permission on the tables in order to
    > modify their design.
    >
    > For back-ends that exist in remote locations, sending the administrator of
    > the location a database that includes code, queries, etc. that automates
    > the changes is common. Still, the user must have permission to modify the
    > table design.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Or you could write code that connects to a new Workspace & Applies the
    changes through that
    that will offcourse only work if the Dbowner hasn't been removed from the
    ..mdw file the customers got

    something like

    Dim Db As DAO.Database
    Dim Ws As DAO.WorkSpace
    Dim TDef As DAO.TableDef
    Dim Fld AS DAO.Field

    Set Ws = DbEngine.CreateWorkspace("WS" & Timer(),"SuperUser","Secret")
    Set Db = Ws.OpenDatabase(CurrentDb()) ' Or Normally Path to Backend - which
    can be found quite easily through code

    On Error Resume next

    Set TDef = Nothing
    Set Tdef = Db.TableDefs("XXX")
    If TDef is Nothing Then
    ....... etc ....


    Pieter



    "Larry Linson" <bouncer@localhost.not> wrote in message
    news:%236wnZJAsGHA.596@TK2MSFTNGP04.phx.gbl...
    >
    > "Len" <Len@discussions.microsoft.com> wrote
    >
    > > I am looking for references on how to upgrade
    > > BE database automatically by Admin user when:
    > >
    > > 1.New fields has been added to BE tables or even
    > > new tables created
    > > 2.The RWOP approach has been used in development.
    > > As a result Admin does not have any permissions
    > > on the BE tables

    >
    > Normal way to upgrade back-end is for the person with permission on the
    > Tables to open a copy of the back-end directly (when no other users have
    > access), make the modifications, regression test, and replace the
    > production back-end. You must have permission on the tables in order to
    > modify their design.
    >
    > For back-ends that exist in remote locations, sending the administrator of
    > the location a database that includes code, queries, etc. that automates
    > the changes is common. Still, the user must have permission to modify the
    > table design.
    >
    > Larry Linson
    > Microsoft Access MVP
    >




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

Share This Page