Limited access to records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Penny - 31 May 2005 00:47 GMT

Is it possible to limit which records in an access database that a user can
see? I would like to make a database that holds students test scores, etc,
and would like to give them access to the database, but only to view their
test scores without being able to see the other tests scores that are stored
for the other students.

Thanks

Mark

Reply to this Message

John Vinson - 31 May 2005 03:31 GMT

>Is it possible to limit which records in an access database that a user can
>see? I would like to make a database that holds students test scores, etc,
[quoted text clipped - 5 lines]
>
>Mark

You'll need to implement Access Security on the database. This is a
fairly complex operation and can easily be done *wrong*. Get the
Security Whitepaper from Microsoft:

http://support.microsoft.com/?kbid=207793

Read it carefully. Sleep on it. Read it carefully, AGAIN. Print it out
and follow its instructions step by step as you secure your database
(AFTER you've made a doublechecked backup!).

What you'll need to do is block access to the Tables (or any
unrestricted forms, reports, or queries on the tables), and provide
the students with *only* RWOP queries which select their own data.
(Yes, the FAQ explains RWOP... read it!)

It may be prudent to get a couple of your brightest and most curious
students, ones you can trust, and challenge them to crack the
security. Fix the holes that they discover before releasing it to the
general student body... :-{)

John W. Vinson[MVP]

Reply to this Message

Jeff Conrad - 31 May 2005 04:27 GMT

> Is it possible to limit which records in an access database that a user can
> see? I would like to make a database that holds students test scores, etc,
> and would like to give them access to the database, but only to view their
> test scores without being able to see the other tests scores that are stored
> for the other students.

In addition to the link John mentioned, I recommend ALL of the following
reading material:

http://www.ltcomputerdesigns.com/JCReferences.html#Security

Pay special attention to RWOP queries.

Signature

Jeff Conrad
Access Junkie
Bend, Oregon

Reply to this Message