makea queries available without allowing access to entire databas.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jo - 16 May 2008 01:23 GMT

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.

Reply to this Message

Damon Heron - 16 May 2008 19:01 GMT

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

>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
[quoted text clipped - 4 lines]
> Two issues - ease of navigation by all users and security of personal
> information.

Reply to this Message

Jo - 19 May 2008 00:21 GMT

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
[quoted text clipped - 13 lines]
> > Two issues - ease of navigation by all users and security of personal
> > information.

Reply to this Message