VBA实现SE的多用户记录
    点此下载全文
引用本文:王福东.VBA实现SE的多用户记录[J].计算技术与自动化,2016,(4):95-98
摘要点击次数: 797
全文下载次数: 0
作者单位
王福东 (武汉数字工程研究所湖北 武汉430074) 
中文摘要:FactoryTalk View SE在画面数据监控及控制等方面具有强大的功能,提供适用于工业的实时数据采集、显示、数据的归档、报警以及报表等功能模块,但在操作的用户记录方面尤显不足,然而在一些双重身份验证的系统中,往往需要同时记录操作用户及监护用户,以方便事故追忆和历史查询。本文利用FactoryTalk View SE内嵌VBA,通过ODBC接口链接SQL Server数据库,实现操作的双重身份验证与记录。
中文关键词:SE  VBA  多用户  数据库
 
VBA to Realize SE Multi-user Records
Abstract:FactoryTalk View SE has powerful function in the picture data monitoring and control area. It provides function 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.
keywords:SE  VBA  Multi-user  database
查看全文   查看/发表评论   下载pdf阅读器