Search results

One reservation I have is that if something ever happens to my license, I can't use my app outside the service like I can with Access runtime. In that sense it is truly SaaS (Software as a Service).

Using Power Apps hosted by Dataverse and used within a Teams environment, it appears to me that this is the solution Microsoft intends for organizations to develop internal business apps quickly going forward. In that sense, it occupies the same space as Access, but it goes further in that they...

Right. It's intended for select folders mostly and not a whole-PC backup, and doesn't do incremental backups as a proper backup service would do. Think of OneDrive on the PC like browsing Google Drive or your OneDrive online, only you're working with the files on your PC with an online sync...

It's possible that many of those interactions with other Office apps (and even non-MS apps) can be handled by Flows in Power Automate: That may very well be the intention of Microsoft as you work within the MS 365 ecosystem. Including Power Apps. I agree Access doesn't have a replacement but...

Having no experience with SharePoint I had to look further. It turns out you can create relationships: Create list relationships by using unique and lookup columns Still, there will be limits depending what you want your apps to do – which means if you want a desktop Access front-end and a...

It actually looks like they took PowerPoint and Excel and Access and blended them together. No VBA. But there are "formulas" used in a similar-looking bar as Excel. I wouldn't be able to criticize much without getting my hands on it but I know that for many, no VBA or query editor means it can't...

I suppose you don't have to define relationships at the table level, though I do so I have things mapped out for myself and to provide defaults throughout the database. Power Apps can't do code, though. So I'm unsure how you'd go about building a Power App for mobile that reads and writes to...

Relevant: Can Power Apps replace Access?

I've heard there can be performance issues when relying on Sharepoint instead of SQL, which worries me. I'm also not sure how we would create a relational database in SP.

$10 per app per user per month (one app used at a time), or $40/user/month for unlimited apps

I discovered an unfortunate limitation yesterday. Apparently using Power Apps via the MS 365 license comes with some limitations to data connectors, one key one being SQL server. Therefore creating a Power App for mobile use to connect to the same back end db you're using with your desktop...

So as I was writing the original post here it appears Microsoft has been hard at work on this problem.

To circle back on this -- this is included with a MS 365 Business plan (pricing is per user), so it's a much better deal than subscribing a la carte. Also, while you can build a standalone app, you can also put it right in Teams if you're using that: This is some really impressive stuff MS...

Please do share your thoughts on the above question. Thanks.

@TJ01 thank you for the update. I am going through this process myself per my recent post: https://www.access-programmers.co.uk/forums/threads/is-access-the-right-solution.315123/ So if I can change a couple of variables: If you were not willing or able to spend the time to learn PHP, and If...

It depends how your business is set up, but here's what I do: Database resides on an internal (government) network Database is .accde - no one has the .accdb except for me This .accde is locked down - bypass is disabled, ribbon is disabled, options menu is disabled, right-click menus are...

Monospaced fonts are best for coding...

I mentioned this before. I know it exists, I just don't know how to get it. Microsoft uses it in their Access help.

Users who are above my level and thus outside my rights to train. It's too bad.

I mean it's new to these folks at my workplace. They don't seem to trust Access because a previous database they made was a disaster. It wasn't set up for multiple users which restricted entry to one person at a time and they kept trying to use an unbound form which was throwing all kinds of...