Link Table

[SRN]

What's the Best Way.

My problem is I am linking into a Table in a Personnel Database, the table holds sensetive information. What I need to do is be selective in what fields i want from that table and somehow link to those fields. If anyone can suggest an easy & secure way of doing this. Thanks

 

[lipin]

What about using a make-table query to create a new table. In the query, select only the fields you need. And then link the new created table.

 

[RichMorrison]

This is what you want to do:

1) In the MDB that contains the personnel table, remove all permissions for the group Users. Add permissions for the group Admins.

2) Open, as a member of group Admins, the MDB that "links into" the personnel table.

3) Create a query that selects the fields you want to make viewable. Set the "run permission" of this query to "Owner". That means the Owner of the query is a member of group Admin.

Summary:
+ you have denied all members of group Users any permission to open the personnel table and see its content
+ you have created a query that exposes some fields
+ you have allowed members of group Users the ability to run the query and view the result

RichM