change object ownership

C

cmledbetter

I know that in my original research prior to starting this project I found a
means to change the ownership of objects after implementing user level
security. In an existing Access 2003 db it hs become necessary to implement
security and place the db on a network drive. In order to make a clean
application I reworked the existing db and made all my queries rwop as well
as created rwop queries on each of my tables. At this time my problem is that
I did this work on an unsecure db therefore admin is the owner of all my
objects. How do I change the ownership of these objects once I run the
security wizard following steps posted on Joan Wilde access pages.

I just cannot find where the explanation of ownership change was located.
 
J

Joan Wild

Although you can change the ownership of objects via the Tools, security,
permissions dialog, you cannot change the owner of the database object.

You need to create a new database while logged in as the user you want to
own everything, and import all the objects from your database.
 
C

cmledbetter

Thanks,

I feel silly. Found both solutions shortly after posting question, sorry.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top