Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
user-level security in Access 2007
- Thread starter group6
- Start date
BlueHorizon
Instructor
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.
HTH,
Best,
Blue Horizon![[2thumbsup]](/data/assets/smilies/2thumbsup.gif "[2thumbsup] [2thumbsup]")
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.
HTH,
Best,
Blue Horizon
BlueHorizon,
Are you sure your Access 2007 file is not in 2003 format? I wasn't aware ULS was supported in the new 2007 format.
Duane
Hook'D on Access
MS Access MVP
Are you sure your Access 2007 file is not in 2003 format? I wasn't aware ULS was supported in the new 2007 format.
Duane
Hook'D on Access
MS Access MVP
- Thread starter
- #4
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 Blue Horizon is correct about the Database Tools Tab...
"User-level security does not exist in an .accdb file"
But Blue Horizon is correct about the Database Tools Tab...
That is not correct, valgore.
Access 2007 fully supports ULS.
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...
Roy-Vidar
Access 2007 fully supports ULS.
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...
Roy-Vidar
- Status
Similar threads
- Question
- Locked
- Question