Just want to link to 4 fields from a table

[LMB]

Hello,

Using Access 2000. I have an employee database. Now I have created a new
database and I want to link my records to my employee table but I only want
the new database to make visible the employeeID, LName, FName, and MInitial
and not sensitive information like ss number. Is there a way to do that
without setting up security? My new database is already made and the
queries, forms are using the tblEmployee.

Thanks,
Linda

 

[Jeff Boyce]

Even if you added security, a persistent intruder could probably bypass it.
If your users are ONLY using forms to access the data, link to the other
table/database, create a query that ONLY returns the fields you wish them to
see, and use a form to display that info.

(if your users look at the tables, or write their own queries/SQL in
procedures, they'd still be able to see other fields).

A more drastic, and labor-intensive (your labor) approach would be to use
code to open a link to the other db/table, update a "local" table with ONLY
the fields permitted, then break the link.

How hard do you want to work at this, and how secure is "secure"?

 

[LMB]

I wouldn't have time to update the table each time a change was made but
perhaps the secretary could do that manually on a weekly basis.

Thanks,
Linda