Security

[h3llz]

How can i secure a form / query / table with password, or have logins? if the
solution is logins, will there be a variable of who logged in? ty in advance

 

[S.Clark]

In the future, please feel free to post security questions in the Security
forum.

If you are using an .mdb, then you can use full Access User Level Security.
It is a pain, and it's not 100% secure, so it will only keep the honest
people out. I prefer to implement security within the application. Create a
login page, store their password in a table, compare it, and then you could
store the value in a variable. After log-in, you could store info into a
table about who logged in when, what they accessed, etc. (If you use AULS,
then you can use CurrentUser.)

Whichever method you choose, when the form opens, check that the user has
the proper permissions.

 

[Larry Linson]

I prefer to implement security within the application.

You may prefer it, but what you describe is even less secure than classic
Access security.

Larry Linson
Microsoft Office Access MVP

 

[S.Clark]

Yes, but if true 'security' isn't really the issue, then why bother with the
headache of AULS. Just keep out the nosey-nellies and go.

How you been Larry?

-Steve

 

[Larry Linson]

How you been Larry?

-Steve

Aha! _That_ S. Clark, eh? I'm doin' OK, Steve. As one of our mutual friends
has been known to say, "Still old, fat, and ugly."

Are you still doing business at the same old stand? We've missed your bright
and shining face.

You know that I've "fessed up" to doing a "Security Lite" back in Access 2.0
days, but after strongly cautioning the prime contractor and the client that
it was not secure in the least. Hey, it was their system, and they were
convinced not any of their users were knowledgeable enough to circumvent it.

I most often use the Windows login ID (see the APIs at
http://www.mvps.org/access) as the basis, instead of a table. Depending on
the implementation, that may require a nosey-nellly to jump through a few
more hoops.

Larry

 

[S.Clark]

"ITS PRONOUNCED TAAAAAVES!"

I left the former popsicle stand to enhance my SharePoint knowledge. I have
a little downtime right now, so I like to pop in and annoy the Access MVPs.
Keep up the good work.

 

[Larry Linson]

<CHUCKLE> You left off the "dammit" part.

Best of luck with your new venture. Thanks for the kind words.

Larry