Hiding fields from individual users?

[Guest_imported]

Can any one help me with hiding fields in a database from selected users?

 

[MichaelRed]

xact,

Unless you 'secure' the database, I know of no way to do this. After you apply the security, it is 'easy' - but tedious.

In the security administration, you define user groups based on the 'needs' of the group, and then make the users members of the group(s) which they require.

Back in the mundane world of programming, you need routine(s) to check the Users name aginst the various groups, and set controls properties (.visible) based on the group membership.

A [red]LARGE[/red] caution. Ms. Access security is complex and confusing. MAKE a back up of your db before attempting to apply it. Another caution - do not use the default name for your security module - it leave the db very open to even unintentional hacking.

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[Julio]

There's another way, but it also needs securing the DB.
Is to create a set of queries with only the fields you want, set them to run "with owner access", and then take give the different users permissions only to the defferent queries and not to the table.

HTH