passwording database

[daneo2k3]

Can anybody tell me how i can set up a password system onto my database i have a table with the 3 names i want to use and there passwords in the password format but i dont know how to set up a form so the only when the name and password you enter on the form match that of the ones from the table can you access certain forms etc? cheers dane

 

[dcx693]

Why not use Access' built-in security system. It providers very granular control over user rights.

 

[ColinEssex]

Does the password and name then allow the people different levels of access to the DB?

Yes it does - sorry I missed the last bit of your post

Col

 

[Mile-O]

This might be a little complex but here's a Login system of mine (nothing to do with Access Security) that I used once - I've tidied it up to take (hopefully) all references to other stuff within my database out.

It uses two Class modules which deal with logging in from an unbound form. It has the most basic of encryption too and an "I've forgotten my password, send it to me" button.

In no way do I say that it's "secure" but if you want to see an example of a 'basic' password system then, by all means, browse this.

When you first open the database it should write your System ID to the table. The password is 'example'

 

[daneo2k3]

i want to create it a bit like you have but im doing a query but what do i need in the criteria so that it the data in the form has to match that off the table? thanks dane

 

[mr moe]

Mile-O-Phile
I like your example, but the only thing is that the email feature is not working. I get an error variable not defined "pAppName"!!!!

 

[Mile-O]

Mile-O-Phile
I like your example, but the only thing is that the email feature is not working. I get an error variable not defined "pAppName"!!!!

That's a Constant I use should I want to refer to a name for the database. Any reference to it can be removed from the code.

 

[daneo2k3]

ive tried importing your logon example into my database to use it but when i try and use it, it brings up errors in the code? i have designed a logon form myself and got a table with the 2 users names and there passwords but how do i get it so that when you type the name and password and click ok on the form, that it has to match the one in the table before you can open the next form??? please can you help its doing my head in and i dont really know what im doing with the code side of things. cheers dane

 

[quijote]

help

Hi,
I was trying to run your example but when the form opens to ask me for the password I get the error message undefined getusername function. If I press ok I can go to the form but no User Name is fill and I can not update the field, if I try the password, I get incorrect password. Thanks for the help

 

[Parker]

This might be a little complex but here's a Login system of mine (nothing to do with Access Security) that I used once

Hi Mile

Neat example. Don't know why people having problems with it it worked fine for me first time. It even converted to 2002 with no hickups.

are you going to drop that one in the repository?

 

[Mile-O]

I will do; going to tidy it up first.

 

[Parker]

I will do; going to tidy it up first.

Great.

How about including a disable shift key and hide table routine. That would make it a very good low level security module for those that need it.

Cheers

Pete

 

[schumarg]

Hi,

I've been looking and adapting your Login/Password code, and I'm making a little progress. Very impressed, it's what I've been trying to do for some time now.

Would it be asking too much for you to post the other part that deals with changing, creating new users and password. Also, can not figure out how you encrypted the password.

Thanks in advance (a bit thanks)
Bob

This might be a little complex but here's a Login system of mine (nothing to do with Access Security) that I used once - I've tidied it up to take (hopefully) all references to other stuff within my database out.

It uses two Class modules which deal with logging in from an unbound form. It has the most basic of encryption too and an "I've forgotten my password, send it to me" button.

In no way do I say that it's "secure" but if you want to see an example of a 'basic' password system then, by all means, browse this.

When you first open the database it should write your System ID to the table. The password is 'example'