Limited access to records

[Mark Penny]

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

 

[John Vinson]

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

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]

 

[Jeff Conrad]

in message:

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.