PC Review


Reply
Thread Tools Rate Thread

Code for database user access

 
 
Tammy S.
Guest
Posts: n/a
 
      22nd Feb 2010
I have a database with a field I want to restrict access to. Each user has a
user ID that they use to log into the network. That ID was used for the
Security Wizard. Some of the users are permitted to see SSNs and others are
not. The old version of the databse has code that uses the network ID to
determine if the user can see this info after clicking on the "Show SSN"
button. I am unable to replicate this code.

Also, I'd like to have the user's ID automiaticall populate the "Entered By"
field whenever they enter a new record.

I have a table for all database users listing their name and user ID. They
all have permissions to use forms only with one granted admin rights as a
back-up for me.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP: VBA Code to extract data from an SQL Server database and put it into Access Database Clinton M James Microsoft Excel Programming 1 8th Oct 2007 12:44 AM
Backup database from code: Access denied on user specific directories Robin Microsoft Dot NET Framework Forms 3 1st Jun 2007 10:50 AM
VB6 - Access ADP Database Custom Property / Or Read Line of Code In ADP Code Module WhatTha Microsoft Access VBA Modules 0 24th Jan 2006 03:26 PM
setting up a multi user database in access 97 database =?Utf-8?B?RWR3YXJkIExldGVuZHJl?= Microsoft Access 1 31st Mar 2005 03:10 AM
Overiding user msaaccess database user rights via vba code =?Utf-8?B?QXZpYnk=?= Microsoft Access Security 1 5th May 2004 03:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:56 PM.