Change Owner of the Database

  • Thread starter Thread starter Tony_VBACoder
  • Start date Start date
T

Tony_VBACoder

How do I change the owner of the database in Access 2002?

I used the User-Level Security Wizard to secure my
database. Because we have a Novell network, the Security
Wizard made the owner of the database my Novell login ID -
TONY123. However, my Novell login ID is not the actual
name I want to use as the Owner of the database, so I
created a new user that I want to actually be the true
owner of the database. I added this new user to the
Admins group. Now, when I login as TONY123, I want to
change the owner of this database by going into
Tools>Security>User and Group Permissions. When I click
on the "Change Owner" tab and select "Database" from the
Object Type combo box and then select the user from
the "New Owner" combo box for whom I want to set as the
new owner of the database, the "Change Owner" button is
disabled.

How can I switch the owner of the database?
 
Tony_VBACoder said:
How do I change the owner of the database in Access 2002?
Click to expand...
You cannot change the owner of the database via the dialog.
How can I switch the owner of the database?
Click to expand...

Sign in as the user you want to be owner. Create a new database and import
all objects.

Note that all the imported objects will not have the permissions - you have
to reassign them.

You can script out the permissions using code in dbutilities at
www.daiglenet.com in the Access section.

Is it really worth it?
 
Back
Top