VBA实现SE的多用户记录

VBA to Realize SE Multi-user Records

FactoryTalk View SE在画面数据监控及控制等方面具有强大的功能,提供适用于工业的实时数据采集、显示、数据的归档、报警以及报表等功能模块,但在操作的用户记录方面尤显不足,然而在一些双重身份验证的系统中,往往需要同时记录操作用户及监护用户,以方便事故追忆和历史查询。本文利用FactoryTalk View SE内嵌VBA,通过ODBC接口链接SQL Server数据库,实现操作的双重身份验证与记录。

FactoryTalk View SE has powerful function in the picture data monitoring and control area. It provides func- tion modules suitable for industry such as real-time data acquisition, display, data archiving, alarm, report and so on, but in aspect of user record it is especially inadequate. However, it often needs to record user operation and to monitor the user at the same time in some dual authentication system, so as to facilitate the accident tracing and history inquiry. This paper used the FactoryTalk View SE embedded VBA to link SQL Server database by the ODBC to realize dual authentication and records of operation.