Change Ownership of Database Object (?)

  • Thread starter Thread starter croy
  • Start date Start date
C

croy

When working with User Level Security, is it normal for the
owner of a database to *not* be able to change the ownership
of the database object?
 
Yes (assuming you mean via the security dialogs). You normally change
the owner of the database object, by creating a new mdb while logged in
as the user you want to own the database.

If you need to change the owner, you'd create the new database, and then
import all the objects from your old database. The permissions won't
travel with the import, so you'd use a utility such as Jeff Conrad's to
transfer the permissions...
http://www.accessmvp.com/SDaigle/index.htm

Joan Wild
MS Access MVP
 
Yes (assuming you mean via the security dialogs). You normally change
the owner of the database object, by creating a new mdb while logged in
as the user you want to own the database.

If you need to change the owner, you'd create the new database, and then
import all the objects from your old database.
Click to expand...

By "you'd", you mean the prospective new owner, right?
The permissions won't
travel with the import, so you'd use a utility such as Jeff Conrad's to
transfer the permissions...
http://www.accessmvp.com/SDaigle/index.htm
Click to expand...


Thanks Joan. Another keeper!
 
Back
Top