基于Access开发的安全策略研究

Research on Security Policy Based on the Development of Access Database

为了满足Access开发的安全性需求,放弃其自带的密码保护,采用全新的安全策略,在开发的产品中禁止直接使用Access自带的功能,设计用户登录验证系统,并将其设为优先启动,利用VBA代码对敏感信息进行加密解密保护,并依据用户角色启用或禁用<Shift>键.实验结果表明,超级用户(程序员)通过验证后可用<Shift>键阻止窗体启动来修改数据库对象和代码,其他用户通过验证后只能进入各自的主窗体来使用软件,非法用户则无法窥探、使用和修改,从而确保了Access开发产品的安全性.实践证明,采用这种安全策略后,Access的安全问题将不再困扰用户,能让Access发挥更大的作用.

In order to meet the security requirements of Access development,to give up its own pass-word protection,use the new security strategy,through the experimental study,to prohibit the direct use of the Access built-in function in the development of products,design of user login authentication system and set it to boot priority,using VBA code to protect sensitive information with encryption and decryption,and basis user role to enable or disable the ＆lt;Shift＆gt; key using.The results show that after verification the super user （Programmer）can use the ＆lt;Shift＆gt; key stop form start and modify the database obj ects and code,other users through validation can only enter the main form of each to use the software,the illegal user can not snoop,use and modify,to ensure the safety of Access product development.Practice has proved that,after using this security strategy,the user will no longer be troubled by the problem of security of Access,and the Access can be played as a greater role.