Security without Login

D

deb

I need to secure my database without having a login form.

I have about 50 users and need 3 types of access. read only, read/edit/add
new, and Admin/Full.

As the user opens the DB it checks the current user name against the tblUser
and allows access if the user exists in the table. I does not prompt for
login or password. If user does not exist, it displays msg to request DB
permissions from DB Admin.

Does anyone have the code for this? I am a bit lacking in the coding
department!!

Thanks in advance!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Security & Windows Login 1
need help with security 1
Admin and User Security using a login form 0
1 user gets when "admin" in use - but no login/password prompt 8
Security - Am I missing something? 4
Bypass A2003 security 1
What Permissions to Create User 1
How can I switch the current user from the default (Admin)? 1

Top