Database authentication

[Tina]

Hi! I'm actuall just started learning to develop simple system using
microsoft access. So, basically I'm a beginner that really needs some expert
help..

My question:
1. I have 3 different type of users (User, Approver & Admin).
User can create request accordingly. Each request will need an approver to
approve. The system will prompt a login screen for approvers and validate if
the users login is an approver. If yes, the it will open the form for further
update. If no, the system should not allow the person to view the form.

2. Will we be able to hide the database and convert the system to .exe file
so that nobody would be able to edit the database except for the system
administrator.

Appreciate anybody could help me.

 

[John W. Vinson]

Hi! I'm actuall just started learning to develop simple system using
microsoft access. So, basically I'm a beginner that really needs some expert
help..

My question:
1. I have 3 different type of users (User, Approver & Admin).
User can create request accordingly. Each request will need an approver to
approve. The system will prompt a login screen for approvers and validate if
the users login is an approver. If yes, the it will open the form for further
update. If no, the system should not allow the person to view the form.

You'll need to implement Accesss workgroup security. Download the Microsoft
Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it, completely and carefully. Get a good night's sleep.
Read it AGAIN, even more carefully. Follow its steps to the letter. It's very
easy to do security wrong!

2. Will we be able to hide the database and convert the system to .exe file
so that nobody would be able to edit the database except for the system
administrator.

Access does not provide this capability. An Access database is not an
executable program and cannot be made into an executable program. You can save
the database as a .MDE file, which has the code compiled, the source code
deleted, and provides no form or report design tools; but this .MDE file must
be used by running the Access program msaccess.exe.

John W. Vinson [MVP]

 

[Dennis]

Ahh, but John, you CAN set the individual table properties to HIDDEN (and if
the user doesn't have SHOW HIDDEN TABLES set to YES, they won't see them.
Also, you canset the Startup option to not show the Objects Window. Of
course, both of these issues can be easily gotten past, but it would serve to
keep the neophytes from seeing anything.