How to connect Access to Firebase Realtime Db ? (1 Viewer)
- Thread starter amorosik
- Start date
- Local time
- Today, 07:43
- Joined
- Jan 23, 2006
- Messages
- 15,379
I don't know Firebase, but did find this info
All Firebase Realtime Database data is stored as JSON objects. You can think of the database as a cloud-hosted JSON tree. Unlike a SQL database, there are no tables or records. When you add data to the JSON tree, it becomes a node in the existing JSON structure with an associated key.
And, since Access doesn't handle JSON natively, it may not be the friendliest pairing.
I found this via Google https://github.com/adarshmadrecha/MSAccess-Firebase-Integration
All Firebase Realtime Database data is stored as JSON objects. You can think of the database as a cloud-hosted JSON tree. Unlike a SQL database, there are no tables or records. When you add data to the JSON tree, it becomes a node in the existing JSON structure with an associated key.
And, since Access doesn't handle JSON natively, it may not be the friendliest pairing.
I found this via Google https://github.com/adarshmadrecha/MSAccess-Firebase-Integration
Here's the way:
Access on the cloud
They will update sales and stock on hand form other locations I'm assuming they are working with their local stock. In that case, it is not critical for the updates to be real time for the other loculations. As long as each location keeps their stock up to date, they can communicate in batch...
www.access-programmers.co.uk
