摘要
针对当前模架结构和尺寸的多样化要求,之前只能实现国家标准模架的一键式绘图的系统对于非标准模架的设计绘图已不再适用,提出将开放式A ccess数据库应用到该系统中,利用A uto C A D内嵌的V B A二次开发工具,通过V B语言编程,将V B A通过A D O接口与A ccess数据库连接并能够对其数据进行访问、添加、修改、删除等操作,在标准模架图库管理系统的基础上添加非标准模架设计系统模块;通过试验,证明了A uto C A D、V B A和A ccess数据库具有良好的兼容性,实现了非标准模架设计的一键式绘图。
According to the requirement of the diversity of mold structure and size,the system that can only achieve the national standard mold drawing design is no longer applicable for the nonstandard mold design. This paper applies open Access database in the system to solve the problem. By using VBA development tools embedded in Auto CAD and the VB language programming, the VBA and Access database are connected using ADO interface, and its data can be changed,such as inquiry, add, modify and delete. And nonstandard mold design module is added to the standard mold gallery management system. Experiments prove that Auto CAD, VBA and access database have good compatibility. One-touch drawing of nonstandard mold design are realized.
出处
《机械工程师》
2017年第2期29-32,共4页
Mechanical Engineer
基金
北京市教委面上项目(项目号KM201310011002)
关键词
数据库
VBA
二次开发
图库
data base
VBA
second development
gallery
