
Hi,
I have been tasked with updating an Access Database that whilst it has some limitations, has been developed and refined for more than 10 years and is working well. Most tables are number based, there is lots of calculations and a gazillion relationships. There all sorts of calculated fields that's numbers will change by simply tabbing off the field and before any save or add button is pressed. Database size is about 700mb, Access Front End is about 200mb in size.
My approach was to use PowerApps with a Sharepoint back end to contain costs.
Simply creating a table with say multiple related items that have fields that change as described above had been quite difficult and required a lot of work (with variables) to come even close.
Im beginning to wonder if my approach has been the best solution?
Would love to hear any thoughts
Regards
Todd