Upgrading BE database

[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.

 

[Larry Linson]

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

 

[Pieter Wijnen]

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

 

[Pieter Wijnen]

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

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

--