Re: import security definitions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Don't use the addin; use Sandra's code that the addin was based on.

DBUtilities 1.0 part way down this page:
http://www.daiglenet.com/MSAccess.htm


--
Joan Wild
Microsoft Access MVP
"Mag. Andreas Wöckl" <woeckl@xxxxxxx> wrote in message
news:O%23vl5xSTHHA.1000@xxxxxxxxxxxxxxxxxxxxxxx
Hi Joan!

If I use the Access ADD-In I can only select a source and a target DB - I
can not select a table to copy the permissions to..

How can I use the code without the wizard?

Thanks in advance

andy

"Joan Wild" <jwild@xxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:O37ZJHSTHHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
I would use Sandra's code to do this. Open DB1 and run the code to copy
the permissions to a table.

Open DB2 as new owner, import all the objects. Open the permissions
table and change 'Administrator' to 'xy'.

Then use the code to load the permissions.

--
Joan Wild
Microsoft Access MVP
"Mag. Andreas Wöckl" <woeckl@xxxxxxx> wrote in message
news:%23XgPB9RTHHA.4784@xxxxxxxxxxxxxxxxxxxxxxx
Hi Guny!

I still have a litte problem:

DB1 is owned by Administrator (I have to take the permissions of this
database)
DB2 is owned by user "xy" - I imported all objects of DB1 to it

Now I want to transfer the security permissions - If I open DB1 as
administrator and try to transfer - I get an error message that I do not
have permissions on DB2 - If i open DB2 with my workgroup file and user
"xy" I get the message that I do not have permissions to DB1.

That seems to be an issue of ownership - do you know a workaround?

Andy

"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
schrieb im Newsbeitrag news:ecvCRmHTHHA.5012@xxxxxxxxxxxxxxxxxxxxxxx
Hi, Andy.

Is there a chance to migrate the permissions - it was a lot of work!

Use Access MVP's Sandra Daigle's and Jeff Conrad's DBUtilities utility
to copy the permissions from the old database to the new database.

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.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

"Mag. Andreas Wöckl" <woeckl@xxxxxxx> wrote in message
news:upv71UHTHHA.4276@xxxxxxxxxxxxxxxxxxxxxxx

Hi Group!

I have the following problem: I had to define very complex security
permissions on various groups for an access database. I forgot to take
away the permissions and the ownership of the administrator - so it it
still possible to open the mdb directly. So If I Import the objects to
a new database - I do not have the permissions that I have set!

Is there a chance to migrate the permissions - it was a lot of work!

best regards

andy









.

Relevant Pages

  • Re: access or network problem ?
    ... The first thing to check is whether or not ALL users have full permissions ... 'types' of user - User, and Administrator ... The database is accessed via icons on desktop ... Double click icon - opens access then displays access error message ...
    (microsoft.public.access.security)
  • Re: Fresh installation and no access
    ... You're not getting access because you're not an administrator when you log ... In previous OS's you had administrator permissions on the database ... You must create a login (to allow connect to SQL Server) then a user to be ...
    (microsoft.public.sqlserver.security)
  • RE: Error opening database.
    ... desperation to making progress. ... Have your system administrator or the ... person who created this object establish the appropriate permissions for you." ... I have tried to create/open a database in my account ...
    (microsoft.public.access.setupconfig)
  • Re: Probs accessing database for users of newly developed Superuse
    ... Holding down the shiftkey does not bypass any security permissions, so if that succeeds, then you don't have a permissions problem with the database object. ... my Superusers aren't using the database yet. ... administrator and change what I need to change then I log out. ...
    (microsoft.public.access.security)
  • Re: can not open MDB file
    ... > To remove User-Level security on your Microsoft Access ... > that defines security for the database that is secured. ... Grant full permissions to the Users group and the Admin user account ...
    (microsoft.public.access.security)