web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapps and Access
Power Apps
Answered

Powerapps and Access

(0) ShareShare
ReportReport
Posted on by 725

Hi all

I have been enjoying Powerapps greatly and committed a lot of time and effort into learning the platform, still a noob by a long shot. My reason for taking on the challenge is the company where I work has a 20 year old Linux database for our inventory tracking. It's really showing its age and some of it's limitations are really getting in the way. Management is still slightly on the fence regarding Powerapps and are considering Microsoft Access for their new database system (which I currently have no experience with). However, from what I gan gather, Access and Powerapps don't seem to natively intergrate.

We are a mussel processing plant with roughly 120 staff. Data entry for production happens in about seven different locations in the plant and my thinking was with PA I could make very user friendly interfaces for each department for data entry with a very small learning curve. I have been at this plant for ten years, so I'm not a new upstart wanting to turn the place on it's head, I consider the place well managed. However there currently is a lot of manual transposing of data which consumes a lot of time for the admin staff.

So I guess my question is, what do companies normally marry with Powerapps? & any opinions about Access?

Categories:
I have the same question (0)
  • eka24 Profile Picture
    20,925 on at

    Currently you cannot connect to Access with Powerapps. You can look at this article on various Datasource and their strength to make your decision

    https://baizini-it.com/blog/index.php/2017/08/29/powerapps-101-data-storage/

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • rubin_boer Profile Picture
    4,843 Super User 2024 Season 1 on at

    hi there

     

    Is there any specific reason you leaning towards Access and not SQL or mySQL.  

  • R Bakker Profile Picture
    725 on at

    I'm leaning very much towards SQL,  I could be wrong here, but I guess they see Access as something familiar to what they know IE Excel. 

  • Verified answer
    PaulD1 Profile Picture
    2,914 on at

    Azure SQL is inexpensive (about $25 / month for an S0 DBaaS offering) and far preferable to an Access fileshare database (for resilience, backup, capabilities).

    Connecting Power Apps to Azure SQL requires purchasing additional licensing (10$ per user per App per month). If you are only entering data from Windows desktops in your organization, then an Access Front End to an Azure SQL Db would be a very low cost, very easy to implement solution.

  • R Bakker Profile Picture
    725 on at

    Thanks for your reply.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,045

#2
Valantis Profile Picture

Valantis 675

#3
11manish Profile Picture

11manish 592

Last 30 days Overall leaderboard