Access is a useful small Microsoft database. The database is used in office settings as well as for smaller system setups. More demanding applications are not suitable for Access because of lack of multiple user profiles and a limited performance scope. The OPC Router connects Access databases to other systems within the higher system architecture of any company.
That’s how easy it is.
The transfer object of the Microsoft Access plug-in allows access to Tables and Views in the Access database. The Access database is a data file.
Select, update, insert and delete actions are available for the tables. After successful processing of data sets they can be marked as transferred by the OPC Router.
Views are only accessed as a select query.
The Microsoft Access plug-in does not have its own triggers and therefore works with the standard triggers of the OPC router.
The Microsoft Access Plug-in can browse the available tables and views from the Access database.
Tables and Views
All tables and views can be accessed by the user are read from the database system. The columns and their types are determined and made available for selection.
Here you will find further information
about OPC Router and Plug-ins.