Applying 2007-2010 User Level Security

[CharlieT302]

Looking for ideas...

Now that Access has eliminated user-level security in the new file format, what are others doing to secure their dbase objects. I realize the security model was not "fool-proof," but it was better than not having any security.

Does anyone have suggestions as to locking users out of specific forms, tables, etc. Is this simply a matter of us having to program our own security schemes now or is there another viable solution? Curious about what others are doing to resolve this.

 

[Remou]

I think the general idea is that if you want ULS either don't use the accdb format - it is still available with the mdb format, or use SQL Server back end.

http://lessthandot.com