change object ownership

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top