Transfer ownership from a secured database

[fugifox]

I have a secured database with one admin account PAdmin1,
who is the owner of the database. Let's call the mdw file associated with
this database sec1.mdw

What I want to do is to transfer the ownership to an other account, PAdmin2, which is defined by a second security file sec2.mdw.

The problem is that when I am trying to import all the objects of the first database to a new blank database associated with sec2.mdw I ,obviously, get an error message saying that I do not have the privileges to do so.

Any ideas of how can I achieve what I want to do?

 

[apr pillai]

UserName and UserID

You must create the same User-Name and UserID, that you have used to create the User-Profile in the First Workgroup file, in the 2nd Workgroup File and set the same privileges as well.

If the User-Name is same but the UserID Code is different then it will not work.

http://www.msaccesstips.com/2006/11/microsoft-access-security.shtml

www.msaccesstips.com

 

[fugifox]

It works, thanks!