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

Status
Not open for further replies.

group6

IS-IT--Management
May 19, 2005
42
US
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?

Thank you. Thank you very much.




 
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]
 
yeah. there is no User-Level security in Access 2007.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top