Unable to change owner for the Database object

[Bosch]

I have Access 2003 and I am trying secure my database.
I read thru the posts in this forum and I created a new mdw file and new id..I gave this new id all the powers of Admin, so that I can take away all the powers from Admin user and Admins Group...but I am unable to change owner for the database object..current owner is Admin.

What can owner do that admin cannot do?

Please help..

Thanks a bunch.

 

[andyski101]

Run security wizard, it will do that and more for you.
The owner can always get into the database, this is why you want to run the wizard and have the owner changed to you.

 

[Bosch]

Andy..thanks for the response..
I could only find "user leve security wizard" under Tools> Security>
I tried it (but I canceled after several steps without finishing it)..but it seems to create users and groups with different permissions...

Its not doing anything for ownership change. I only want to change the ownership...everything else I manually did it and I am happy with it..

Is there a way?

Thanks

 

[andyski101]

Changing ownership is something the wizard does automaticly at the end of the process as well as create a backup copy of your database. The way the wizard changes owners is by copying everything into a new database with that has a new owner. If you can create a blank database with the new owner you could do the same thing. I have no experience doing this however, sorry.

 

[Bosch]

Andy..
Finally I ran the USER-LEVEL security wizard (Access 2003). After it is complete, I see the owner is changed to <Unknown>.
I dont know how to interpret that..

But then I get error msg that I dont have access to my backend.
I ran the security wizard on my front end..I have a separate thread on this..

Thanks..