A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Fingerprint Scanner



 
 
Thread Tools Display Modes
  #1  
Old August 27th, 2008, 04:27 PM posted to microsoft.public.access.tablesdbdesign
Doctor Dan
external usenet poster
 
Posts: 1
Default Fingerprint Scanner

I have been asked to develop an application which uses the persons
fingerprint as his record identifier. Intsble design I am not sure how to
code this correctly. Also in the application, once the person's fingerprint
is scanned and accepted I want to make the program continue on with having to
hit the enter key. Can anyone share some ideas on this? I am sure there are
lots of people doing this.
  #2  
Old August 27th, 2008, 05:35 PM posted to microsoft.public.access.tablesdbdesign
Jay974 via AccessMonster.com
external usenet poster
 
Posts: 9
Default Fingerprint Scanner

Could you not have the fingerprint scan output to a text box and use the
after update property to have it do what you want it to.

Also, you can set the input mask to password to ensure that no-one can
replicate the scan string.

--
Message posted via http://www.accessmonster.com

  #3  
Old August 27th, 2008, 06:05 PM posted to microsoft.public.access.tablesdbdesign
Klatuu
external usenet poster
 
Posts: 7,074
Default Fingerprint Scanner

Do you mean a document reference number or some other reference number that
identifies the scan? If you want to use the Actual scan image, Access
doesn't handle binary data that well.

Some questions (assumning you mean a reference identifier of some kind)
How are you connected to the Scanner?
Does it save the image as a file?
If so, do you have a way to know where the file is being saved?
Can the scanner pass the identifier or the image's path and file to Access?
If so, how are you doing that?
Is there other information entered about the person?
Is it entered before or after the scan?

Is this statement correct?
"I want to make the program continue on with having to hit the enter key"
or did you mean to say "without"?

--
Dave Hargis, Microsoft Access MVP


"Doctor Dan" wrote:

I have been asked to develop an application which uses the persons
fingerprint as his record identifier. Intsble design I am not sure how to
code this correctly. Also in the application, once the person's fingerprint
is scanned and accepted I want to make the program continue on with having to
hit the enter key. Can anyone share some ideas on this? I am sure there are
lots of people doing this.

  #4  
Old August 27th, 2008, 09:00 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Fingerprint Scanner

This might be the wrong forum, as the Access portion of this would be
straightforward. The real crux of this is what gets stored & compared for
the fingerprints nad how such is done.

Most of the systems that use it in lieu f passwords etc. don't store an
image of the fingerprint. They extract, store and compare attributes of
them..
  #5  
Old August 27th, 2008, 09:37 PM posted to microsoft.public.access.tablesdbdesign
Klatuu
external usenet poster
 
Posts: 7,074
Default Fingerprint Scanner

Fred,
You would know more of the technology than I. I assume it would be some
sort of digital representation, but I don't know if it would be an image or
some sort of vectory graphics, or what, but my original point is that that
data could not really be used as a primary key, I don't think. I also know
that Access is not a good choice if you need to store large binary data. SQL
Server would be a better engine for that.

--
Dave Hargis, Microsoft Access MVP


"Fred" wrote:

This might be the wrong forum, as the Access portion of this would be
straightforward. The real crux of this is what gets stored & compared for
the fingerprints nad how such is done.

Most of the systems that use it in lieu f passwords etc. don't store an
image of the fingerprint. They extract, store and compare attributes of
them..

  #6  
Old August 27th, 2008, 10:17 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Fingerprint Scanner

Hello Dave,


Just to clarify, I wasn't commenting on your response.

I'm not in that business either, I just know a little about it, being in a
related field (Machine Vision, which includes automated image processing)

There are systems that store the entire fingerprint (e.g. police, FBI etc).

And there are the everyday systems (password replacers etc.) that (have to)
make a point of being able to say that they DON'T store the fingerprint (not
in any format), they just extract and store just enough attributes of the
fingerprint to be able to determine if it's the same fingerprint the next
time the system sees it.

A part of their motivation is the PR advantage to help overcome objections
of people who don't want their fingerprints scanned and stored...so they can
say they aren't storing the actual fingerprints.

It didn't work on me. The last time someone (Meijers) told me they needed
that, I left $350 worth of groceries at a checkout counter for them to put
away and bought them elsewhere.

Sincerely,


Fred

  #7  
Old August 27th, 2008, 10:25 PM posted to microsoft.public.access.tablesdbdesign
Klatuu
external usenet poster
 
Posts: 7,074
Default Fingerprint Scanner

I didn't think you were, Fred. I was happy you jumped in.
I haven't had anyone except my bank want a fingerprint yet. I'm with you.
They have more info than the need already.

--
Dave Hargis, Microsoft Access MVP


"Fred" wrote:

Hello Dave,


Just to clarify, I wasn't commenting on your response.

I'm not in that business either, I just know a little about it, being in a
related field (Machine Vision, which includes automated image processing)

There are systems that store the entire fingerprint (e.g. police, FBI etc).

And there are the everyday systems (password replacers etc.) that (have to)
make a point of being able to say that they DON'T store the fingerprint (not
in any format), they just extract and store just enough attributes of the
fingerprint to be able to determine if it's the same fingerprint the next
time the system sees it.

A part of their motivation is the PR advantage to help overcome objections
of people who don't want their fingerprints scanned and stored...so they can
say they aren't storing the actual fingerprints.

It didn't work on me. The last time someone (Meijers) told me they needed
that, I left $350 worth of groceries at a checkout counter for them to put
away and bought them elsewhere.

Sincerely,


Fred

  #8  
Old August 29th, 2008, 01:53 AM posted to microsoft.public.access.tablesdbdesign
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default Fingerprint Scanner

Doctor Dan wrote:

I have been asked to develop an application which uses the persons
fingerprint as his record identifier.


You will need to use an API call as defined by the fingerprint scanner
manufacturer. I'd start with them.

BTW if I was an employee and your employer insisted on fingerprints
I'd quit. smile

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
  #9  
Old August 29th, 2008, 09:27 AM posted to microsoft.public.access.tablesdbdesign
Brendan Reynolds
external usenet poster
 
Posts: 1,241
Default Fingerprint Scanner

"Tony Toews [MVP]" wrote in message
...
Doctor Dan wrote:

I have been asked to develop an application which uses the persons
fingerprint as his record identifier.


You will need to use an API call as defined by the fingerprint scanner
manufacturer. I'd start with them.

BTW if I was an employee and your employer insisted on fingerprints
I'd quit. smile

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/



I did some work on this a couple of years back. As you say, Tony, you have
to start with the vendor of the scanner, as the methods used to store the
fingerprint or the representation of the fingerprint will differ from one
vendor to another. As Fred says elsewhere in this thread, they don't
necessarily store the fingerprint itself. The one we used stored a
representation of the fingerprint using a one-way hashing algorithm, and the
vendor assured us that it was not possible to re-create the image of the
fingerprint from the stored data. To work with the data in Access, I had to
use a byte array.

We eventually shelved the project for two reasons. One, the scanners were
too slow for our purposes, and two, despite the fact that actual fingerprint
images were not stored, potential customers were still uncomfortable with
the idea of scanning fingerprints.

--
Brendan Reynolds

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.