Copying security to new mdb

[Guest]

I would like to create a database for which I am the owner, then copy or
import the user security from an existing mdw. Can it be done without
manually entering all of the users and permissions?

 

[Jeff Conrad]

Well you don't actually copy the permissions from the MDW file,
you copy them from the MDB file. Only Users and Groups info
is stored in the MDW.

You can script out the permissions using MVP Sandra Daigle's
code here:

http://www.daiglenet.com/msaccess.htm

Look for DBUtilities 1.0 and DBUtilities 1.1 about half way
down the page.

I rolled elements of that code into an add-in that will automate
the whole procedure. The add-in is on the same page at the
top. Look for the first two files and download the version you
need. Read the instructions carefully and make sure you make
backups before beginning.

Neither of these utilities will copy out users and groups from
the MDW file. You'll probably need to do that manually.

Good luck,
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Guest]

Thanks Jeff. I really wanted to get the users and groups as well. If you
open a new db after having logged in via workgroup, the users and groups are
included in the new db, but you can't change the owner of the db. My real
goal is to have the new db with the same users, groups, and permissions, but
with a new owner.

Thanks.

Greg

 

[Joan Wild]

Thanks Jeff. I really wanted to get the users and groups as well.
If you open a new db after having logged in via workgroup, the users
and groups are included in the new db, but you can't change the owner
of the db. My real goal is to have the new db with the same users,
groups, and permissions, but with a new owner.

Just create a new db while logged in as the new owner. Then import all the
objects and copy the permissions over.

 

[Jeff Conrad]

in message:

Thanks Jeff. I really wanted to get the users and groups as well. If you
open a new db after having logged in via workgroup, the users and groups are
included in the new db, but you can't change the owner of the db. My real
goal is to have the new db with the same users, groups, and permissions, but
with a new owner.

Well the users and groups are not "included" in the new DB per se.
The MDW file holds all of the users and groups information. You
can *utilize* those users and groups with the database that is
currently open (assuming of course they have sufficient permissions).

Just follow Joan's advice and create a new database with the Owner,
import all the objects to own them, and then transfer the permissions.
Make sure you have lots of backups as well before beginning.

 

[TC]

You can script-out the user and group /names/, but you can not get the
PID values that were used to create them originally, so you can not
recreate the users & groups through code, using any normal method.

HTH,
TC

 

[Guest]

OK thanks all. I suspected it couldn't be done, but wanted to ask. There is
a commercial app called JAM that may do it.

Greg