J
Jim Moore
I am new to Access and have the following question:
I have an Access97 application that I want to programmatically restrict
Access to the application itself and to limit a users right to read and/or
update records in other Tables within my application.
My application consists of a Front End database and numerous linked Tables
from Backend databases.
The primary Table of my application, called Personnel, that is in a Backend
database called HumanResources.
The Personnel Table contains the following fields:
Last_Name
First_Name
Middle_Name
SSN
Job_Title
Position
Location
(I believe that I will have to duplicate the Personnel table from the
backend database HumanResources and place it in the front end to accomplish
this task)
When my application starts I want to programmatically collect the following
information:
Retrieve the Domain a user is logged in to
Network name of the current machine (Computer Name)
Network logon ID of the current user (User Name)
Full name of the user currently logged in
With the data above collected I want to programmatically perform the
following analysis:
1) User is logged into a valid (known) Domain. (Domains will be listed in
the code - We have 7 Domains in our Enterprise)
a) If user is not logged into a known Domain then I want to display a Dialog
"Access is Denied" then when user clicks OK the application closes.
b) If user is logged into a known Domain then continue validation process
2) User Name matches positions 3-12 of the Computer Name (to ensure the user
is using
their assigned computer to access the application)
a) If user is not logged into their own computer then I want to display a
Dialog "Access is Denied" then when user clicks OK the application closes.
b) If user is logged into their own computer then continue the validation
process
3) Validate that the Full name of the user currently logged in exists in the
Personnel Table (Fields Last, First, Middle)
a) If the full name of the user currently logged in does not exist in the
Personnel Table I want to display a Dialog "Access is Denied" then when user
clicks OK the application closes.
b) If the full name of the user exists in the Personnel Table I want to
continue
With the above satisfied I then want to prompt the user for their User Name
(previously determined)
a) If the user name entered does not match the user name of the current user
logged into the computer then I want to display a Dialog "Access is Denied"
then when user clicks OK the application closes.
b) If the user name entered matches the user name of the current user logged
into the computer the I want to prompt the user for their SSN
When the user enters their SSN I want to validate that against the SSN
stored in the Personnel Table
a) If the SSN entered does not match the SSN for the user attempting to log
in the application I want to display a Dialog "Access is Denied" then when
user clicks OK the application closes.
b) If the SSN entered matches the SSN for the user attempting to log in the
application they are granted access.
Once access is granted to a user I then want to limit their access
(Read/Write/Delete) to certain data fields (in Forms) based on their
Job_Title; Location and Position.
Thank you in advance,
Jim
I have an Access97 application that I want to programmatically restrict
Access to the application itself and to limit a users right to read and/or
update records in other Tables within my application.
My application consists of a Front End database and numerous linked Tables
from Backend databases.
The primary Table of my application, called Personnel, that is in a Backend
database called HumanResources.
The Personnel Table contains the following fields:
Last_Name
First_Name
Middle_Name
SSN
Job_Title
Position
Location
(I believe that I will have to duplicate the Personnel table from the
backend database HumanResources and place it in the front end to accomplish
this task)
When my application starts I want to programmatically collect the following
information:
Retrieve the Domain a user is logged in to
Network name of the current machine (Computer Name)
Network logon ID of the current user (User Name)
Full name of the user currently logged in
With the data above collected I want to programmatically perform the
following analysis:
1) User is logged into a valid (known) Domain. (Domains will be listed in
the code - We have 7 Domains in our Enterprise)
a) If user is not logged into a known Domain then I want to display a Dialog
"Access is Denied" then when user clicks OK the application closes.
b) If user is logged into a known Domain then continue validation process
2) User Name matches positions 3-12 of the Computer Name (to ensure the user
is using
their assigned computer to access the application)
a) If user is not logged into their own computer then I want to display a
Dialog "Access is Denied" then when user clicks OK the application closes.
b) If user is logged into their own computer then continue the validation
process
3) Validate that the Full name of the user currently logged in exists in the
Personnel Table (Fields Last, First, Middle)
a) If the full name of the user currently logged in does not exist in the
Personnel Table I want to display a Dialog "Access is Denied" then when user
clicks OK the application closes.
b) If the full name of the user exists in the Personnel Table I want to
continue
With the above satisfied I then want to prompt the user for their User Name
(previously determined)
a) If the user name entered does not match the user name of the current user
logged into the computer then I want to display a Dialog "Access is Denied"
then when user clicks OK the application closes.
b) If the user name entered matches the user name of the current user logged
into the computer the I want to prompt the user for their SSN
When the user enters their SSN I want to validate that against the SSN
stored in the Personnel Table
a) If the SSN entered does not match the SSN for the user attempting to log
in the application I want to display a Dialog "Access is Denied" then when
user clicks OK the application closes.
b) If the SSN entered matches the SSN for the user attempting to log in the
application they are granted access.
Once access is granted to a user I then want to limit their access
(Read/Write/Delete) to certain data fields (in Forms) based on their
Job_Title; Location and Position.
Thank you in advance,
Jim