Read Only Link Query or Table

We have a peer to peer network in our office and use Access to store
confidential information.

I would like to create a secondary database with either a linked table or
query that will enable certain employees to access a subset of information
from larger database.

Is something like this possible?

"=?Utf-8?B?QWNjZXNzIDIwMDMgVXNlciBOYW1lcyAmIExvZ2luIGlzc3 Vlcw==?="
oft.com wrote in
:


I would like to create a secondary database with either a linked table
or query that will enable certain employees to access a subset of
information from larger database.



You don't need to create another database: the built-in Access user
security is designed for exactly this purpose. Lots of details in the help
files and on ms knowledge base. Make sure you understand it, and take lots
of backups, before going live on your real data!

HTH


Tim F