Home All Groups Group Topic Archive Search About

Database Owner - Admin

Author
7 Nov 2007 7:28 PM
croy
When I try to change owner of a database, I can't,
presumably because I'm not logged in as the owner.

So, while logged in as a member of the Admins group, I
create a new, empty database with a different name.  I check
the ownershipe for the database and find, "Admin"!

Why would a database created by me be owned by Admin?

--
Thanks,
croy

Author
8 Nov 2007 5:36 AM
datAdrenaline
So ... you opened Access, opened a database, then got prompted for a userID
and password, which you entered as <youruserid> and <yourpwd> respectively. 
Then used the File New to create a new database .... and the db Owner was
'Admin' ?
---
Also, AFAIK not even the db owner, and change the owner of the database. I
am pretty sure the owner is determined by the workgroup user who creates the
db.
--
Regards,
Brent Spaulding | datAdrenaline | Access MVP


Show quote
"croy" wrote:

> When I try to change owner of a database, I can't,
> presumably because I'm not logged in as the owner.
>
> So, while logged in as a member of the Admins group, I
> create a new, empty database with a different name.  I check
> the ownershipe for the database and find, "Admin"!
>
> Why would a database created by me be owned by Admin?
>
> --
> Thanks,
> croy
>
Author
8 Nov 2007 2:40 PM
croy
On Wed, 7 Nov 2007 21:36:00 -0800, datAdrenaline
<datAdrenal***@discussions.microsoft.com> wrote:

>So ... you opened Access, opened a database, then got prompted for a userID
>and password, which you entered as <youruserid> and <yourpwd> respectively. 
>Then used the File New to create a new database .... and the db Owner was
>'Admin' ?


Exactly.  To add a little precision to that, the owner of
the *newly created* mdb is "Admin" (as was the owner of the
mdb originally opened).


>---
>Also, AFAIK not even the db owner, and change the owner of the database. I
>am pretty sure the owner is determined by the workgroup user who creates the
>db.


Hmmm.  I must be missing the obvious (I do that a lot...).

But...  if your last statement is correct, how, could the
Owner of my new mdb, created by me while logged on as an
Admins Group member other than Admin*, be listed as "Owner"?

New thought: Is there a blending of realms, here?  Could
there be cross-pollination between the Windows NT file
system and the ownership in Access?  I'll check into that
with one of my Cheech & Chong tools (Try This!).


    * The user, "Admin" has been removed from the
      "Admins" group.

Thanks for your thoughts.

--
croy
Author
8 Nov 2007 4:41 PM
croy
On Thu, 08 Nov 2007 06:40:22 -0800, croy <c***@invalid.net>
wrote:

Show quote
>On Wed, 7 Nov 2007 21:36:00 -0800, datAdrenaline
><datAdrenal***@discussions.microsoft.com> wrote:
>
>>So ... you opened Access, opened a database, then got prompted for a userID
>>and password, which you entered as <youruserid> and <yourpwd> respectively. 
>>Then used the File New to create a new database .... and the db Owner was
>>'Admin' ?
>
>
>Exactly.  To add a little precision to that, the owner of
>the *newly created* mdb is "Admin" (as was the owner of the
>mdb originally opened).
>
>
>>---
>>Also, AFAIK not even the db owner, and change the owner of the database. I
>>am pretty sure the owner is determined by the workgroup user who creates the
>>db.
>
>
>Hmmm.  I must be missing the obvious (I do that a lot...).
>
>But...  if your last statement is correct, how, could the
>Owner of my new mdb, created by me while logged on as an
>Admins Group member other than Admin*, be listed as "Owner"?


Correction on the last of that:  "...be listed as "Admin"?


>New thought: Is there a blending of realms, here?  Could
>there be cross-pollination between the Windows NT file
>system and the ownership in Access?  I'll check into that
>with one of my Cheech & Chong tools (Try This!).


Now I am reminded that these files are on a FAT32 drive!


Show quote
>    * The user, "Admin" has been removed from the
>      "Admins" group.

--
croy

AddThis Social Bookmark Button