Can I connect React to an Access ACCDB
Is there a way to connect/read/write to an Access ACCDB from a React app?
We have a customer that is using a Access MDB for their data and wants a React application written that will run on a mobile device.
Can you please give helpful information and examples of how to do this?
Last Comment
ASKER
We will be making a web app with React that will allow approximately 5 mobile devices to track inventory. The goal would be to keep SQL out of the picture and write directly to the Access ACCDB if possible. If that isn't possible, then we will need to just connect to a standard SQL database then update the Access ACCDB with the current Access program that is written as we are currently doing with the currently used Xamarin application. The Xamarin application is cumbersome due to the steps needed to update devices when changes are made to the app.
[..] to keep SQL out of the picture and write directly to the Access ACCDB if possible [..]First of all, SQL and Access are equivalent in this scenario.
The only question is: How do you want to make an internal database available to the outside world?
You have only two options:
- An internal server hosting the database in the DMZ.
- An external server hosting a replicated database (over VPN).
ASKER
This will be a intranet application only. I should have mentioned this. I am sorry.
ASKER
From some of the things I am seeing there should be a way with a OLEDB connector. Is this correct and is it the only answer?
No. An OLEDB connector is just a implementation detail of minor interest. You need to make some architectural decisions first.
ASKER
It looks like we got the OLEDB connection working.
This will be a intranet application only. I should have mentioned this. I am sorry.Yup.
Then it is a "simple" ASP.NET web API or node.js running in your internal network.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Depending on the use-case, number of concurrent users and required/desired reactivity (latency), you need to evaluate a separate database server like SQL Server and replication. This includes moving the data storage for the existing database to the same database server or additional, manually replication steps.