User accounts with admin

[alvarogueva]

Well;

Hello there

I am trying to create users with acc and password with multi level access. where they can see some tabs or text box depending of the level you have.

Is there anything like that out there? We kind of manage some private information ( addresses, emails ) and we want some managing employees to be the only ones with access.

Also, is there a way to put a password protected in a Button that opens a folder in a remote location? I would like to save some documents in those and I don't want my employees to have access unless I am present and I put the password at the moment.

Thank you all guys!!!!

 

[Ranman256]

I would have the tUser table,but no need to store passwords. I would use the Windows authentication for their already existing windows passwords.
DO have their userId in the table to allow them into the database.
The user would also have a field for Access. This code would say how much access the user can view.
I have
A=admin
M= manager
No code = general user.

When the form opens, get the userId ,then lookup the access code.
The buttons,and queries are access able for certain codes.

 

[alvarogueva]

I would have the tUser table,but no need to store passwords. I would use the Windows authentication for their already existing windows passwords.
DO have their userId in the table to allow them into the database.
The user would also have a field for Access. This code would say how much access the user can view.
I have
A=admin
M= manager
No code = general user.

When the form opens, get the userId ,then lookup the access code.
The buttons,and queries are access able for certain codes.

That is a great idea! The problem is that our computers do not have passwords in the log in. Also, i would like to keep it reduced to access only. Is there other option i can take in order to create this???


Thank you!!

 

[CJ_London]

Also, is there a way to put a password protected in a Button that opens a folder in a remote location? I would like to save some documents in those and I don't want my employees to have access unless I am present and I put the password at the moment.

How do you plan to stop users using Windows Explorer to navigate to that folder?

 

[alvarogueva]

How do you plan to stop users using Windows Explorer to navigate to that folder?

Wait, what??

I guess i did not say it correctly. This is a front end and back end database; they can just click in the button now and check any document. What i wantfrom them to not be able to open those folders unless there is a password in there.

 

[CJ_London]

What i wantfrom them to not be able to open those folders unless there is a password in there.

I understand you don't want your users to be able to navigate to them through your app. My question is what is to stop them navigating to them using windows explorer?

 

[alvarogueva]

I understand you don't want your users to be able to navigate to them through your app. My question is what is to stop them navigating to them using windows explorer?

They can't. The folder is not in the cloud, is in a server... and That is for what it is for, so they cannot access the folder...

Did I missed anything? LOL