Hi,
i'm using an offline database that i upload on onedrive and download every time in two PC.
Since i'm going to use powerapps too i need some online server but i don't want to need always connection when i use my access database.
So i was thinking to have a local copy of every sharepoint list (i used sharepoint before), and i'm figuring out the best practice to do use this procedure, maybe on opening the database i update the local copies of sharepoint lists or, i dunno, make a copy of every sharepoint list in my database as local tables.
then, on closing database i have to update my sharepoint list from local tables.
i like to work offline also cause it's faster, i have some superheavy vba code and reports, and i saw the difference between offline and sharepoint.
what's your suggestion? consider that i do not use relations in access, i just link tables using comoboxes in forms, and i'd like to stick on that, so no sql server or stuff like that, i need very simple storage
thanks