I'm developing an access control system using the RC522 RFID reader and an infrared sensor, based on a Microsoft Access file. The issue I'm stuck with is the following:
I need Arduino to read the RFID tag, check for some info in Access related to the tag number, and do something depending on the Access result.
For example, the RFID number read is 15. It should check in an Access query if (in some field) 15 corresponds to a 0/1 - yes/no - true/false value. If it is 0, it should play an alarm audio file. If it is 1, do nothing.
I hope you can help me with this.
Thanks in advance!