Access2000 Security, Preventing Access to Tables & Queries

  • Thread starter Thread starter Les Kyser
  • Start date Start date
L

Les Kyser

Is there any way to password protect an Access2000
database application so that a user can have read-only
access to forms but no access (write or read)to the
underlying tables or queries? Thanks for any help you can
provide in this area!
 
Often asked - and answered!

You need to learn about Access user-level security, then learn how to use
Run With Owner Permission (RWOP) queries. This will not be a trivial task.
Locate, download & study the Access Security FAQ. Experiment with some
throw-away databases, before you even think about doing it on your actual
database. Expect to spend >at least a few weeks< before you understand it at
all. Some of the regular respondents to this newsgroup, have home pages with
more information - check their signature lines at the bottom of their
replies.

HTH,
TC
 
Back
Top