Interfacing Microsoft Access Database to Arduino

Using Arduino Interfacing w/ Software on the Computer
1

Hi, I'm sherl and a newbie in arduino programming. I have a project ryt now about interfacing RFID reader, ARDUINO, GSM SHIELD and a database entitled GSM Base Student Monitoring System Using RFID. I have research sample program in RFID, GSM shield to use and I ask my friend to make me a simple database.
Here's what I want to happen in my project:
My RFID reader is connected to the arduino and the read rfid code will be sent to the database to compare if its code was already registered to it. If its already registered then the database will send the information of the read rfid code back to the arduino to execute the program in the arduino in sending the information to the GSM shield to send it to a particular cellphone number. My problem is how to combine the program of the RFID reader and the GSM shield to arduino Mega and how to communicate the arduino to the database. I will also made use of software serial library because both RFID reader and the GSM is in serial connection. I'am using an Arduino mega with two serial ports only.

GSM_Shield_test.ino (1.64 KB)

2

My problem is how to combine the program of the RFID reader and the GSM shield to arduino Mega

Specifically, what is the problem?

That method for reading the serial response is junk. Aside from that, what IS the problem?

You have a sketch that can, apparently, send text messages. You have a sketch that can, apparently, read RFID tags. Combining them to send a text message containing an RFID tag is trivial.

All you need to do then is to create an application that you can send a text message to that can access the database and generate a reply.

Then, when you get the crappy readSerialString() function working usefully, you can do something with the response.

I'd say that right now you have about 2 of the 10 pieces of code written that you need.