Solved Is there any Biometric Attendance Machine that can integrate with Microsoft Access Database

[Khurramshaikh47]

Hi, Is there any Biometric Attendance Machine that can integrate with Microsoft Access Database? I have an attendance system on Microsoft Access in which I manually enter the time-In and Time-Out. Kindly Suggest any biometric device that can connect with my database.
Thank you

 

[Cotswold]

Presumably they are similar to weigh bridges and other devices and will have an RS232 serial port.
If so you can plug a USB serial port into a PC and use comms software to connect via the port. If so,
the hardware supplier should give you the the communications settings for the serial port.

If you can't write the software yourself, take a look at granite.ab.ca but some stuff is out of date, closed down or lost.

Serial Port Communications

Also a UK company may help you

Route Data into a Microsoft Access Database from RS232, RS485 and Modbus Instruments | Windmill Software

www.windmill.co.uk

 

[The_Doc_Man]

You should be able to use any device that has an RS-232-C interface or a networked interface. In the former, you would have to do a READ on the connection. In the latter, you would have to look up use of WinSock protocols - which actually have been discussed in the forum.

The question will be what kind of connection the device needs. The answer will be found in the vendor's user manual for the device. So if you find a few candidate devices on the web, see if you can find their model numbers and do a web search for a manual for that device so you can preview how you would have to connect it.

 

[Khurramshaikh47]

Presumably they are similar to weigh bridges and other devices and will have an RS232 serial port.
If so you can plug a USB serial port into a PC and use comms software to connect via the port. If so,
the hardware supplier should give you the the communications settings for the serial port.

If you can't write the software yourself, take a look at granite.ab.ca but some stuff is out of date, closed down or lost.

Serial Port Communications

Also a UK company may help you

Route Data into a Microsoft Access Database from RS232, RS485 and Modbus Instruments | Windmill Software

www.windmill.co.uk

Thank you

 

[Khurramshaikh47]

You should be able to use any device that has an RS-232-C interface or a networked interface. In the former, you would have to do a READ on the connection. In the latter, you would have to look up use of WinSock protocols - which actually have been discussed in the forum.

The question will be what kind of connection the device needs. The answer will be found in the vendor's user manual for the device. So if you find a few candidate devices on the web, see if you can find their model numbers and do a web search for a manual for that device so you can preview how you would have to connect it.

Thank you