Securing MS Access Application via tbl rather then .mdw

I have an access application that I wrote that is secured using a .MDW file.? The application has a SQL back end and the client would like me to move the security information into a SQL tables.? This will allow the SQL dba and auditors to see who is using the application by viewing the security table.

This is an easy project for the right person.? I am looking for someone to create a blank access database that when loaded? prompts for a user name and password and checks against a table before granting access.? ? The application will just need the form that prompts for a password, and a blank test form that loads after the user is granted access.

The database should load the password checking form on startup, ask for the user name and password and then load a second form call frm_main if the user is authenticated.? All frm_main should do is use a if/then statement to display a msgbox that displays one message "You have user level 1" or "You have user level 2" depending on the value of USRSEC in the security table.

If the user is not authenticated after 3 tries they should get a message box stating "Your password is incorrect" and the application should close.

I will be storing the user login data in a sql table but for simplicity if the bidder wants to put the data inside a table inside of access that would be fine.

REST OF INFORMATION INCLUDED IN DELIVERIABLES SECTION

## Deliverables

Rent A Coder requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite.

TABLE LAYOUT

Suggested Table Structure (Deviation must be cleared).

6 character field names all CAPS.? Below are the minimum fields required to create an acceptable user security table.

USERID? User ID? - Varchar 20

USRPWD? User Password no less than 8, no more than 10 characters including special characters - Varchar 10

USRSTA? User Status field.? Should read “Enabled?? or “Disabled??? Varchar? 10

USRPCD? Password Expiration Date? Datetime? - The stored password should be hashed or encrypted in some way.

USRLAC? User Last Access? Datetime?

USRSEC? User Security Level

Other requirments.

1.? The user needs to log into the application every 30 days to keep their account open.? Upon logon the front end should transmit the date/time of the last logon by the user.? If a user does not access the system after a 30 day period the account should be locked automatically.? If the account is expired a message box diplaying "Your account has expired, please contact the adim to reactive you account" should appear and the the application should change the account status to disabled and then close access.? any time a good login takes place the USRLAC (user last access column) should be updated with todays date.

2.? The password form should require a password change every 30 days.? When the password is changed the USRPCD should be moved foward 30 days.? ? If USRPCD is within 5 days of the current date the user should be forced to change his/her password.? If needed a seperate form can be created to automate the changing of the password of this can be done with hidden text boxes on the form that you authenitcate on.

3.? If password expiration date passes without the password being changed the user should be locked out of the system by changing the status to a disabled status.? And a message box should say "Your password was not changed within the 30 days time limit, please contact your administrator to re-enable your account" and the appliaction should close

Of course any user that tries to login in with an account that is disabled shoudl get a message that says "Your account is disabled."? ? Any any user that can not provide a good userid/password combo should get a message "Not a valid userid/password." and they should not be allowed to enter the appliction.

I have programed in access before and will be able to pull this code into my application and make changes to the msgboxes etc once done.? I am just looking for someone to provide raw code that makes the user authenticate following the guidlines above.

-------------------

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

access 2000/2002

Engenharia Microsoft Access MySQL PHP Arquitetura de software Teste de Software

ID do Projeto: #3563725

Sobre o projeto