MS Access 2003 - Owner DMPhillips 17.07.2006 21:09:01 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?

Re: MS Access 2003 - Owner "Joan Wild" <jwild[ at ]nospamtyenet.com> 18.07.2006 20:17:37 DMPhillips wrote: [Quoted Text] > 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