password protect

[mcnews]

i need a suggestion on how to best setup a password.
i will have a dialog that asked how the main form is to be viewed.
a password will be required if the user wants to access the main form
in using an admin role.
if the password is valid all fields on the main form will be unlocked
and editable.
otherwise they won't get passed the login form unless they accept a
lesser role.

so the question is where/what is the best place/method to hide the
passowrd?

i will not use the access security.

tia,
mcnewsxp

 

[Rick B]

Please do a search and read the hundreds of previous posts on the topic.
Most of them will recommend that you use the built-in User Level Security.
They will point out that rolling your own security will be much easier to
get around than using the proper tools. Most will point out how annoying it
will be for your upper-level employees to be forced to enter a password
every time they want to do their job. Several of those posts do point to
resources that explain how to build a password-protected form or function
though.

Good Luck!

 

[mcnews]

any other takers?

thanks,
mc

 

[Keith Wilby]

any other takers?

I sincerely doubt it. User-level security, though flawed, is head 'n'
shoulders above any home grown solution I've seen. My advice - take Rick
B's advice.

Keith.

 

[mcnews]

I sincerely doubt it. User-level security, though flawed, is head 'n'
shoulders above any home grown solution I've seen. My advice - take Rick
B's advice.

i work in an environment that has given me the benefit of experience
with the access user -level security. people's files are moved around
a lot here and always results in the mdb becoming in-accessable.

 

[BruceM]

If files are moved around a lot then there seem to be problems on top of the
Access issues. Splitting the database may offer something of a solution,
depending on your needs. As Rick suggested, try a search for
password-protected forms if you refuse to use Access user-level security
(which is different from the database security you can select from the
menu). It is difficult to make home-grown security effective, but if all
you are trying to do is to keep honest people honest then it may be enough.

 

[Keith Wilby]

i work in an environment that has given me the benefit of experience
with the access user -level security.

And ... ?

people's files are moved around
a lot here and always results in the mdb becoming in-accessable.

You could always use file permissions to stop that from happening to the
back end and mdw file and deploy a copy of the front end to each user's HDD.

Keith.
www.keithwilby.com

 

[mcnews]

And ... ?


You could always use file permissions to stop that from happening to the
back end and mdw file and deploy a copy of the front end to each user's HDD.

i have no control over what users and network admins forget to do.

 

[Keith Wilby]

i have no control over what users and network admins forget to do.

Some folks just don't want to be helped.

<PLONK>

 

[mcnews]

Some folks just don't want to be helped.

<PLONK>

some folks can't read.

the network environment i work in is not at this point one in which i
can trust that network admins and users will remember to do what they
need to do with their important files and data.

i know all about user level security. i have experienced the problem
that i described too many times sometimes i don't deal with my clients
for a couple of years and when i do hear from them all they want me to
do is unlock their mdb because they can't get into it anymore.

i appreciate you folks who are attempting to *school* me on the proper
rules, but sometimes what you learn in school ain't what happens in the
real world.

so if anyone could simply respond to my request as posted that would be
swell.

BTW - i did the search and didn't find any useful suggestions so i will
cobble together my own version of password proctection.

best,
mc

 

[Gerry Hatrick]

so if anyone could simply respond to my request as posted that would be
swell.

Not gonna happen.

BTW - i did the search and didn't find any useful suggestions so i will
cobble together my own version of password proctection.

Does anyone have any useful suggestions for developing their own wheel?
I have one with corners, is there a flaw in my design?

 

[mcnews]

Not gonna happen.


Does anyone have any useful suggestions for developing their own wheel?
I have one with corners, is there a flaw in my design?

how many dumbasses does it take to answer one question the way is was
asked?

 

[Joan Wild]

If you want to try a home-grown setup have a look at
http://www.utteraccess.com/forums/s...=373275&page=1&view=collapsed&sb=5&o=&fpart=1