Windows Forum

Ask something
Discussion Locked

?? Field security in MS Access '97

0 helpful
3 replies

by tmcnab

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone know if there is security available at the field level for a table? I have some confidential data that should only be seen by a few users.
Our business data is extracted each evening and uploaded into Access databases for users to havereport-writer access to it. So the environment is somewhat open. I have a new tables where a few fields should be hidden.

Thanks,

Tammy McNab
Phoenix Products Co., Inc.

3 replies

by peyison

Tammy,

Access does not support field level security. You can implement this yourself a few different ways.

One way would be to create a separate table for the secured fields and do a one to one join with the original table. Then set up the desired security for the secured table. The average user could access the original table, but if a user had rights, they could access a query joining the two tables. This would require a modification to your upload procedure, but it seems like the easiest way to do this.

Hope this helps.

This discussion is closed to new replies.