UI actions in action
In the example presented in this section, we want to establish a data exchange between two applications that can’t do this: a Microsoft Access database and a Windows Desktop application. This scenario is illustrated in the following figure:
Figure 6.1 – Orders to Invoices structural view
In this scenario, a database application has been created with MS Access. This application may be used by multiple users through network sharing and contains information about customers and suppliers. The users can also store orders from the customers in this database, but the invoices to customers need to be processed via another application for some reason. This application is a Windows executable program that is running on the desktop of a user.
Microsoft Access database as a source system
The database we are using in this example is a sample database provided by Microsoft. Starting MS Access from the program taskbar in Windows...