View Full Version : Copy and paste security permissions from copies of a db


Erin Cimbrie
07-11-2007, 12:09 PM
I have to make a new copy of a db starting with a blank db and importing all the objects into the blank. (Corruptions issues).

When a blank db is made, and the objects imported into it, the security permissions do not copy over. The only way I know how to get the security permissions back is to redo them in the new copy. It's a big db. Lots of time. Ugh.

Is there any way to copy and paste the security permissions from one db to another?

Thanks

freakazeud
07-12-2007, 05:19 PM
Hi,
I think the permission information is actually stored within the mdb file so importing everything into a new application will get rid of them and you would need to reapply them manually. There is a utility here (http://www.daiglenet.com/MSAccess.htm) which promises the following:
DbUtilities 1.0
Utilities to copy permissions from an existing database and then reapply the permissions to a new database with the same structure. Useful when a new database must be created by importing objects into a new database.
I've not worked with this so I cannot promise anything.
HTH
Good luck