Can this even be done?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My boss needs an inventory database (which I've compiled) where people may
have access to some records without full access to the entire document. Is
there a way to make it so that anyone can do a query on only certain data,
without being able to view the entire database? Note that we are not
networked in the traditional sense. This would be a case of someone having to
sit at the machine that stores the db, or have it sent to them via
email....not sure if creating workgroups would work in this case or not.

I'm thinking the only real option we have is creating queries and reports
for specific criteria and give only those to the inquiring individuals, not
the entire db....but the boss wants it as I stated above. Can it be done?

Thank you so much for any help you can provide.
 
What you need to do is a combination of the 2. Implement user level security
and then create RWOP queries to provide individual users with what they need
to see. The process for implementing user level security is described in the
Security FAQ. There is a link to it on the Security page of my website. Read
it several times and follow it to the letter.
 
Thank you, Lynn, much appreciated. So I will have to create these queries
ahead of time (I thought that maybe I could simply protect certain fields
within the same db that wouldn't be visible to a particular user). It might
make better sense for us to just create such queries only when requested and
send only the query results to the requestor.

I will check out your FAQs - thanks again!
 
Back
Top