Looking for some advice.
I currently have a mixture of applications held together (tentatively) by integrations.
Our main Order Processing system is on a Pervasive SQL platform which mean it's impossible for me to access core elements of the data. It's sits right in the middle of all other apps and is the weakest link.
I am looking to rewrite this system in order to bring all of our systems onto the same SQL Server database platform.
The re write would be order processing and Warehouse management.
We have such unique processes here that I see it as a possible solution get around the process issues, and to offer a cost effective solution (all be it medium term)
I know the risk of Bespoke, but even an off the shelf solution would require bespoke intervention.
My question concerns the front End.
We already hae a factory / production system written in Access (SQL back end).
This works quite well.
I was planning to re write the orders and warehouse systems using Access too.
Would you recommend this.
I know there's other dev tools out there like .net and C#.
I know Access well, and know I can deliver all the requirements and more, but would just like someone's overall thoughts on sticking with Access.