Interfacing Access With Arduino Device

[BlueSpruce]

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

 

[BlueSpruce]

Other thread deleted

Sorry Guys, I kept getting this oops message every time I pressed the post button:

 

[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?

 

[BlueSpruce]

Any news on Arduino <- > Access communication?

I have put this project on hold because of other committments. The IoT devices use low-powered, wireless, Class B LoRaWAN that link via outdoor gateways to the Arduino Cloud Platform. So the plan is to build an Access/DotNet interop application that interfaces with the devices registered on the Arduino cloud account via REST API calls.

 

[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.

 

[BlueSpruce]

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.

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.

 

[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.

 

[BlueSpruce]

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.

I reviewed the Azure Iot Hub/SQL video and was unable to gain any new useful info from that presentation because it is specific to the Azure ecosystem. I am still in the Proof of Concept stage. The Arduino ecosystem is much simpler and affordable, whereas Azure's is expensive, has a steeper learning curve, and is overkill for simple, smaller-scale projects.

 

[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

 

[BlueSpruce]

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.

Why leave Arduino just because Qualcomm bought them? So I can switch to another platform like Azure that's more expensive, more complex, and also does widespread data collection?

I already have too much time and money invested in Arduino. I doubt Qualcomm is going to change Arduino from an open source model to a proprietary black box. If Arduino goes sideways on established users like me, they will be facing class action law suits.

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

I'm using the Nano board, not the Uno with the quirks.