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?

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/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"BeagleWillie" wrote in message:
news:2C7D996A-B19B-4CAF-A3EA-(E-Mail Removed)...

> 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?

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

"Jeff Conrad" wrote:

> 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/conrad...essjunkie.html
> http://www.access.qbuilt.com/html/articles.html
>
> "BeagleWillie" wrote in message:
> news:2C7D996A-B19B-4CAF-A3EA-(E-Mail Removed)...
>
> > 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?
>
>
>

BeagleWillie wrote:
> 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.

--
Joan Wild
Microsoft Access MVP

"BeagleWillie" wrote in message:
news:0D572D1C-DF24-48DE-8E1E-(E-Mail Removed)...

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

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

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

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

"TC" wrote:

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