Home All Groups Group Topic Archive Search About

MS Access 2003 - Owner

Author
17 Jul 2006 9:09 PM
DMPhillips
I'm used to Access 97 security, so with 2003 I created a work group file and
a blank database, logged on with MyID and created a new database, which
opened immediately.  MyID was the database owner until I logged out.  When I
logged on again the default 'Admin' user was now the owner.

Is there any way for MyID to retain or obtain database ownership?

Author
18 Jul 2006 8:17 PM
Joan Wild
DMPhillips wrote:
> I'm used to Access 97 security, so with 2003 I created a work group
> file and a blank database, logged on with MyID and created a new
> database, which opened immediately.  MyID was the database owner
> until I logged out.  When I logged on again the default 'Admin' user
> was now the owner.

That doesn't make sense.  Are you certain you were joined to your custom
workgroup file when you created the new mdb?

Be sure you follow every step in securing.

Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm



--
Joan Wild
Microsoft Access MVP