Question on data sources

[diegomarino]

Hi,
since i'm having a nervous attack for all the solution i have explored, i ask here.

I have an access database in which i have no relations, i use comboboxes to fill the correct values. More, i'm the only who uses this database, i just have some shared excel that i produce every time through routines.

I like very much the access table, i used to have sharepoint but i don't like it and i stopped to use; the problem is that i need my data on mobile too, and i use powerapps that's a good solution for my needs.
The problem now is to have shared data between access and powerapps, can u suggest something simple, non relationship way to store data online?

the best for me could be a way to store data on excel, that works with powerapps but with access i can't update values

thanks

[CJ_London]

the thing about the default access database (ACE) is it is a client based rdbms and so far as I am aware powerapps cannot interface with it - it will only link to online data sources.

So you could maintain your data in access and upload updates/additions to sharepoint, rather than working with sharepoint directly. Not tried it but I understand powerapps can link to an online excel file which you could try. Alternatively use an online rdbms such as sql azure.

[diegomarino]

I think I'll make a system by myself. I'll use my Access database and I update spreadsheet on OneDrive (one for every table). When I use powerapps I update those spreadsheet and when I open access I use those spreadsheet as linked table to update records based on modifiedOn field.
It is a bit tricky but also funny

[Micron]

Trying to link Access to OneDrive is ill advised. In fact, pretty sure I even read that at M$oft site recently, but I'm sure you can find many who say to not do this if you look. Downloading and uploading files but working on them locally would be OK.

[diegomarino]

Trying to link Access to OneDrive is ill advised. In fact, pretty sure I even read that at M$oft site recently, but I'm sure you can find many who say to not do this if you look. Downloading and uploading files but working on them locally would be OK.

yes i'll work locally and then upload. i'll make some routines to do that, if someone is interested i'll share my solution

[Micron]

Could work as long as you're not sharing db. If you are, then how do you prevent overwriting files and losing data?

[diegomarino]

yes i'm the one using it.
I'll never use phone and pc together, so the problem is not that big. However i think i'll work with timestamps, i have to build it by scratch but i think i'll do a public function that i can apply to every table