基于VBA编程的数据库建模自动化技术

On the Automation Technology of Database Modeling Based on VBA Programming

在舰船安全监控系统设计过程中,利用VBA开发Access数据库管理工具,解决由于上位机组态软件变量数量庞大,建点工作繁杂,且当用户需求发生变更的时候,重新布点工作量大、耗时长的问题,提高组态软件数据变量建立的效率,快速生成测点分布表,建立清晰的逻辑控制关系,根据用户需求快速调整布点表及变量。

In design process of the safety monitoring system, the use of Access database management tools which developed by VBA can solve the problem of large number of the software data variables, also when the userg demand changes, re-distribu- tion workload. The Access database can make a substantial increase in the configuration software variables to establish the effi- ciency, which can quickly generate the measuring point distribution tables, establish a clear logic control relationship, adjust the distribution table and variables quickly according to the user needs.