How can I give permission to only one record in an MS Access table to one end
user based on their Window terminal password? Or is there a way to have them
sign in before accessing a MS Access Program?

On Fri, 1 Aug 2008 09:31:01 -0700, vallekat
<(E-Mail Removed)> wrote:

>How can I give permission to only one record in an MS Access table to one end
>user based on their Window terminal password? Or is there a way to have them
>sign in before accessing a MS Access Program?

Which version of Access are you using? In 2003 or earlier, you will
need to implement User Level Security and, then, create a RWOP query
for the users for whom you need to limit the records they can read.

Follow the steps in the Security FAQ to implement the security. Check
out the Security page on my website.

Lynn Trapp
www.ltcomputerdesigns.com