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.
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.