Thread: 2003 to 2007
View Single Post
  #5  
Old May 31st, 2010, 12:52 PM posted to microsoft.public.access.tablesdbdesign
sweeneysmsm
external usenet poster
 
Posts: 74
Default 2003 to 2007

Thanks so much. Have to treat myself to a 2007 Access book

Mary

"John W. Vinson" wrote:

On Fri, 28 May 2010 13:47:01 -0700, sweeneysmsm
wrote:

I am still looking for the answer to what happens if someone has a secured
2003 .mdb with its own .mdw but then upgrades to 2007 format. Exactly what
changes. All passwords, permissions discarded? General open entry?


Nothing happens - security still works, *provided* you use the .mdb format.
It's only when you convert to .accdb or .accde format that security goes away.
It doesn't even look at the .mdw file, there is no logon prompt, and none of
the object security specifications are honored.

You can (at least in 2007 or 2010) still use a secured .mdb or .mde file, with
an associated .mdw, and security will still continue to be honored.
--

John W. Vinson [MVP]
.