Interfacing Access With Arduino Device

[Deleted Bruce 182381]

I have been working on my pet project of building an Arduino based IoT healthcare device that integrates with an Access app and wondering if anyone here has done this type of integration.

 

[Minty]

Bit of a stutter going on here?

 

[CJ_London]

Other thread deleted

 

[amorosik]

It depends on how you connect the Arduino board to the outside world
If you connect via Wi-Fi and associate a fixed IP address with the board, the board effectively becomes a web server, which you can query from Access with an HTTP GET request
Better still, if you install an MQTT client on the Arduino board, you can install Mosquitto on the PC where Access is installed (may be other pc in lan), and from Access code you can send and receive MQTT commands
The key is to understand how the Arduino board can communicate with the outside world
Once that's defined, you can then check how to get Access to communicate with the board
What board do you have exactly?

 

[amorosik]

Any news on Arduino <- > Access communication?

 

[GPGeorge]

You might get some ideas from this YouTube video. It was a presentation on using and Azure IoT Hub with SQL Azure, but it has an extensive discussion of use of the IoT devices involved.

 

[GPGeorge]

Thanks, but I have to stay within the Arduino ecosystem since the REST API SDK is used for communication with the IoT devices registered on the Arduino Cloud Platform.

I'm not suggesting you try what was described.

I'm suggesting that, since you are embarking on a new direction of development, there might be useful information available in that discussion regarding interactions with IoTs.

 

[cheekybuddha]

`
You may wish to consider whether you actually want to use an Arduino board going forward.

Arduino was just bought by Qualcomm and the enshitification has begun.

you might also be interested in the quirks of their new board