Adafruit Fingerprint Sensor to MS Access Database

[Jommaria03]

What code would trigger the Ms access database to read and store the Fingerprint ID in the database. Others say that the template can be stored by declaring it as a MEMO. But I want the ID to be stored. So is it possible to store the fingerprint ID in ms access? (note: I'm also using Vb.net which is connected to ms access)

can anyone send a sample code so I have a starting point to create a code?
I want to know what does SEARCH KEY means and what it does... Please help ...

[June7]

You want to scan fingerprint into database? This would be saving an image into Attachment or OLEObject field, not MEMO which is only for text. I expect the fingerprint would have to first be saved as an image file then options are:

1. in text or memo field store path to the external image file

2. store the image file in Attachment or OLEObject field

I don't know what you mean by SEARCH KEY - where is this?

[Jommaria03]

No I want to save the ID to the database. Do you have a sample code for this?

I found out that the search key I'm saying is the primary key in MS access database.

[June7]

What ID? Where does the ID come from? Is this like a barcode scanner?

[Jommaria03]

The fingerprint scanner is the one who gives the ID.

[June7]

The fingerprint scanner is an input device, like a keyboard, mouse, digital pen, barcode scanner - we have weight scales that can be used as input devices. Probably need to install some driver software just like with any input device that allows the computer and device to communicate. As with a mouse or barcode scanner (or our scales), position cursor into cell or textbox on form and press button on input device to transmit data. No code in Access should be necessary.

[Jommaria03]

Thank you sir for replying

What if the fingerprint scanner I have doesn't have a driver, it just depends on it's own code being called?

[June7]

How are you currently using the scanner? If the computer can't see the scanner then how can Access?

Here is a link that offers code for managing computer serial port but I have no idea if it will be useful for you. http://www.granite.ab.ca/access/serialport.htm

You might have to get information from the scanner manufacturer.

[Jommaria03]

Well I use a microcontroller which is ARDUINO and it is connected to the fingerprint scanner.

[June7]

Okay, so the scanner is hooked up to computer through microcontroller. What does that allow you to do with the scanner? I am assuming this is a fingerprint scanner that allows you to image a person's fingerprints. Can you create a fingerprint image file and save it onto computer?

Sorry, you are doing something outside my experience.

[trevor40]

What you need is the Object library of the s/w you are trying to use to connect to Access.
eg if i want to use an Excel or Outlook function i need to add the library to the list of references.
you can then access the functions available from that s/w app.

if you can't find one that is for Access, then ask the manufacturer of the ARDUINO, if they don't have one you are on your own.

but what are you trying to store, the image, scan data, or just that it was a good scan?

[June7]

Ah hah, good point trevor.

These third-party libraries usually seem to be in the form of a dll file and must be installed as add-ins to Access. The only time I ever tried to do this failed.

I think the dll would have to be installed on every computer that uses the database.

[Jommaria03]

Ah hah, good point trevor.

These third-party libraries usually seem to be in the form of a dll file and must be installed as add-ins to Access. The only time I ever tried to do this failed.

I think the dll would have to be installed on every computer that uses the database.

My fingerprint doesn't have a .dll file. So what will be the other solution?

[June7]

Bing: adafruit fingerprint scanner access database library

http://forums.adafruit.com/viewtopic.php?f=25&t=44753

According to that thread, the devices comes with some sort of file.

Contact the manufacturer. Apparently, they even have their own user forum.