Password protection

[Neil_Pattison]

I have a set of command buttons on a form that open up a series of reports. The problem I have is that only certain users should have access to particular reports and I want to be able to put some kind of password protection in.

If anyone knows how to do this please let me know.

Thanks

 

[FoFa]

You could Access security and limit access to those report via that.
You could detect their network login, and limit access via that.
You could handle it manaully on your form and require a password on load and control access that way.

Typically detecting the network ID and doing it behind the scenes without a password works pretty good as the users do not know it is going on.

 

[Neil_Pattison]

Could you let me know the easiest way to get around this by detecting the network ID

 

[ghudson]

MsgBox Environ("UserName")
MsgBox Environ("ComputerName")

 

[Aquadevel]

Passwords

Neil,

Although using Passwords on a control would work, long term looks of the appilication would be better using Passwords for the whole application with level's to allow certain 'button's' to be enabled or not.

Do a search for Security2000.mdb, its works great and you can adapt it to your needs.

My 2 1/2 cents,

Aqua