JIT manufacturing supplier link system.
We were required to design, develop, implement and support an ordering system that was available within Delphi and their Large Global automotive client for 'Just In time' ordering of parts and entire systems.
A WAN link was created between the customers premises and Delphi and dedicated terminals were secured and segregated from normal network operations to form part of the entire system and solution.
Microsoft Access was used as the Front End that would provide alerts, order requests, standard reporting and a messaging system between the two parties. The system initially was piloted as a pure MS Access with VBA solution and upon being successful, the data was moved on a MS SQL environment with high availability and the power of MS SQL was used to improve the stability of the system and to deal with the large quantities of data that was being processed in the 24/7 operation.
The system was so successful that Delphi began implementing versions of the system for other major clients within their portfolio.