Electronic Signatures 1

[RobPotts]

Hi,

I currently have a form which I want to add e-signatures to, is this possible?

When I say e-signatures what I want is for:

a user enters a date in a field, this causes a popup to ask for the user to enter their user name and password.

The user enters this and if it matches the user logged onto the database at that current time then the action is completed.

The user should get 3 attempts before the database is closed down.

I'm using access 2000, some to be upgraded to access 2003, any help would be appreciated.

thanks in advance



Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.

 

[dcurtis]

Assuming that your "e-signatures" are image files add a picture control to your form that will hold the signature. Be default it should be not visible, and it's source should be set to nothing.

In the AfterUpdate of your date field call the form that will check the username and password. On this form you should have text boxes for username and password and a button for the user to click once done entering their information.

In the OnClick of the button on the username and password form your code would look something like this (this code may be a little "loose" and tightened up by someone better at it than me):

Dim int As Integer

	If Me.txtPassword <> DLookup(["[i]PasswordFieldName[/i]", "[[i]UserName/Password Table Name[/i]"], "[[i]UserName[/i] = '" & Me.txtUserName & "'" Then
	Forms![i]Your Original Form[/i]![i]Your Image[/i].Visible = True
	Forms![i]Your Original Form[/i]![i]Your Image[/i].Picture = [i]Path to the signature image file[/i]
	DoCmd.Close acForm, "[i]Your Username and Password Form[/i]"
ElseIf int = 3 Then
	DoCmd.Quit
Else
	MsgBox("Invalid Username and Password")
	int = Int + 1
	Me.txtUserName = ""
	Me.txtPassword = ""
	Me.UserName.SetFocus
End If

I haven't tested the code, but it should work OK for you.

 

[RobPotts]

HI Thanks for this, however what I ant is for the username password look up to look it up on the standard MS Access security, and it will be used to varify that the user making that spcific entery is the person logged on to the DB.

Rob

Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.

 

[dcurtis]

OK, that's beyond what I can help you with. I'm sure there are others in this forum that will be able to walk you through that.

 

[psemianonymous]

I wouldn't implement any sort of e-signature system with Access security, sorry. If you want to enforce accountability, you'd better move the data/user security out of Access.


But it's certainly technically possible to get this done; you just open a connection to the database (and workgroup file) via ADO with the user credentials and the password the user 'e-signs' in with--if the connection is successful, e-sign is successful; if the connection fails with a specific error code, you can tell them 'bad password'; all other errors fail with a standard error message.


It's just not a good idea, as Access isn't secure.

 

[pwomack]

pseale,

Your advice about using e-signatures with Access security is well taken. That being said, will you expand a bit on your post to dcurtis? Can this be accomplished using DAO? What might a connection to the database (and workgroup file) look like? Would you perhaps write some sample code?

Thanks.

 

[psemianonymous]

I've written code to change someone's Access password using a form/VBA but have lost it, sorry. Here's something very similar:

http://groups.google.com/group/comp...=check+password&rnum=6&hl=en#e05964d6fe726671

If this doesn't work, search Google Groups within the 'comp.databases.ms-access' group and I assure you, there will be other examples.

 

[pwomack]

Thank you, pseale. The link you provided will help.

 

[dcurtis]

I am still learning (slowly!) VBA (it is not my primary job.....). I can't help you with the DAO code. Sorry.

 

[RobPotts]

Hi Pseale,

Thanks for the link, have a star. I've tried this and it is definatly a start, and I should be able to code the rest myself (possibly with some more help form you guys).

With regards to MS Access security, From my point of view I have no issues with it, and it performs the task I want it to well. I can apply group level security to my forms and the users can't see the database menu, or most of the menu options on the dropdowns. I'm sure if someone wanted to they could crack the MDW file but it wouldn't tell them alot.

Thanks agian.



Rob! [Bigcheeks]
Process and Procedure are the last hiding place of people without the wit
and wisdom to do their job properly.