There is no user-level security in Access 2007. I guess thats done with the integration of Sharepoint and its security. Is it ok to leave the back end in the old format and use the 2007 front end?
Hi,
There is User-Level Security in 2007. It can be found on the Database Tools Tab/ Users and Permissions icon/ User Level Security Wizard. It acts similarly to the 2003 Wizard.
There is no user-level security in Access 2007" I thought I copied that right out of a MSKB article, but I cant find it now. Maybe I just paraphrased from:
"User-level security does not exist in an .accdb file"
But, the new file format (accdb/accde), which is the format you will want to use if you have a strong desire to use MVF/MVD (Multi Valued Field/Datatype), macros or do extensive interactions with sharepoint, does not support ULS.
There is a distinction between the native databases for Access (Jet/Ace) and MS Access itself (the application, the development tool, ...).
As an aside, Jet 4.0 has always supported more functionality than has been available through the Access interface, say on validation, in the interface, Access supports column level and row level validation (i e, the field validation rule thingie, and what can be found in the table properties, making it possible to validate against another column in the same row). In addition, you can have the Jet engine also perform validation at table level, say for instance to only allow occurrences above average of some column in the same table or another table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.