makea queries available without allowing access to entire databas.

[Jo]

I have developed an employee database which includes private info. I want
users at various PC's to be able to easily access the Next-of-Kin query only
(ie in a crisis situation) but I don't want everyone to have access to the
entire database.

Two issues - ease of navigation by all users and security of personal
information.

 

[Jo]

Thank you Damon

The easiest way is to create a new database and just copy the table that has
the next of kin info in it, then copy the query to the new db. Convert it to
an mde and give that to the users. Of course, you would have to update the
table whenever there are changes.

Other methods involve too many steps to detail here.

Damon