Inconsequential Query

[DickyP]

Generally here on AW users either just use native Access as their data store, or those producing more commercial apps, SQLServer.

I would be intrigued to know what other back ends our contributors may currently use?

I have in the past used Oracle, MySQL and SQLLite, albeit not these days when I use MS Access just for myself only (and for pleasure/fun).

 

[The_Doc_Man]

Currently I'm only on native Access. With the U.S. Navy, we used ORACLE as a BE except for a couple of SQL Server cases. (We had 80 projects but most didn't involve FE operations.) For a while, our electrical engineers used Excel as a data store and then wondered why it was so difficult to use. Which is the first professional project I took for the Navy. Took me a while to wean them from using Access to control Excel like that and start using "pure" Access.

 

[isladogs]

This article may be of interest

What Access Versions are Developers Using in 2025?

Here are some survey results from recent conferences so you can see how your personal usage and expectations differ from them.

www.accessforever.org

 

[MarkK]

Recently I've been querying data over http from SharePoint. Lists exposed on SharePoint are available via phone-based MS Power Apps for users who have an account on our company MS 365 tenant account. For outward-facing data domains this is really cool, because our Access-based ERP system can interact with that same data, effectively moving parts of the ERP online.

 

[GPGeorge]

Recently I've been querying data over http from SharePoint. Lists exposed on SharePoint are available via phone-based MS Power Apps for users who have an account on our company MS 365 tenant account. For outward-facing data domains this is really cool, because our Access-based ERP system can interact with that same data, effectively moving parts of the ERP online.

You didn't call out what I consider to be the primary benefit of this architecture. That is that a PowerApps app, linked to SharePoint Lists and running on a smart device -- phone or cellular-enable tablet, does not require an internet connection. Your ERP is not just online; it's available wherever a user has bars on their phone.