Re: User Level Security in Access 2007

On Thu, 8 May 2008 12:51:54 -0700 (PDT), evenlater
<evancater@xxxxxxxxx> wrote:

I think they removed it because it was never very secure. In future I
will implement role-based security based on membership in Active
Directory groups.

-Tom.


I realize that user level security is not available for Access
databases in the new AK27 format .accdb, and I know that I can still
utilize ULS by making my database an .mdb file.

But I'm wondering WHY Microsoft is scrapping a feature that I've
always found to be extremely useful. Surely they don't expect that
users of the new database format will no longer have a need to assign
permissions at different levels for different users! Why would they
want to make Access LESS powerful for a wide variety of uses?

So I'm thinking they must be thinking that .accdb developers will use
a different method to achieve the functionality previously offered by
ULS. Is the built-in ULS feature unnecessary because the same results
can be achieved using VBA? (Of course, there have always been some
kinds of permissions that can only be managed with VBA -- for example,
ULS can be used to set table-level permissions but not record-level
permissions.)

Also, what are the selling points of the new .accdb format? What
advantages does it have that .mdb does not? I am concerned that if I
develop a new db in the old format that future versions of Access
might not support it.

Thanks for your counsel.
.

Relevant Pages

  • User Level Security in Access 2007
    ... utilize ULS by making my database an .mdb file. ... users of the new database format will no longer have a need to assign ... So I'm thinking they must be thinking that .accdb developers will use ...
    (comp.databases.ms-access)
  • User Level Security in Access 2007
    ... utilize ULS by making my database an .mdb file. ... users of the new database format will no longer have a need to assign ... So I'm thinking they must be thinking that .accdb developers will use ...
    (comp.databases.ms-access)
  • Re: User Level Security in Access 2007
    ... could get past ULS have been advising that if your data was worth US$150 to ... With the new ACCDB in Access 2007, access to SharePoint data is enhanced... ... users of the new database format will no longer have a need to assign ... kinds of permissions that can only be managed with VBA -- for example, ...
    (comp.databases.ms-access)
  • Re: WinPE - what happens to filesystem in these scenarios
    ... In both cases as far as what permissions are there after a format I was ... 'structure' of the filesystem and the 'logic' that is used to work with it? ... or the one in the WIM get used? ...
    (microsoft.public.windows.server.setup)
  • Re: Word 2008: unable to insert image once document is saved
    ... permissions & restarted since applying whatever update you last installed? ... Insert Picture command, I get an error message saying that the image ... format is not recognized by Word. ... by dragging them into place. ...
    (microsoft.public.mac.office.word)