user-level security in Access 2007

[group6]

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.

 

[BlueHorizon]

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

 

[dhookom]

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

 

[group6]

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"

http://support.microsoft.com/kb/918583

But Blue Horizon is correct about the Database Tools Tab...

http://office.microsoft.com/en-us/access/HA101662271033.aspx#1

 

[valgore]

yeah. there is no User-Level security in Access 2007.

 

[RoyVidar]

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