Portable permissions?

[BruceM]

I have a split database with user-level security. The security works as
intended. After completing a beta version of the db I had some users
participate in testing. The testing indicated that more development was
needed, so I made some changes. Finally everything seems to be working as
intended, so I imported into a new blank database (created after logging
into the secure workgroup). The trouble is that I need to re-create the
group permissions in the new database. Is there a way I can bring those
permissions from the old database?

 

['69 Camaro]

Hi, Bruce.

The trouble is that I need to re-create the group permissions in the new
database. Is there a way I can bring those permissions from the old
database?

Yes. Use former Access MVP Jeff Conrad's DBUtilities 2000 Add-in on the
following Web page to copy the permissions:

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

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[BruceM]

What a great utility! Easy to use, clearly documented, and with some extra
reporting features too. Thanks for providing the link. I tested it on a
copy, and it performed exactly as I needed.

 

[Jeff Conrad [MSFT]]

Excellent, I'm glad to hear it helped.


--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com