Microsoft Office 2000/Visual Basic Programmer's Guide

Using Access as a Security Tool

If you're building Microsoft Jet solutions by using a program other than Access (such as Visual Basic or Microsoft Excel), you can secure your solutions by using ADO or DAO. These interfaces give you much of the same functionality that exists in Access. However, to create a secure environment, you must build workgroup information files with the Workgroup Administrator program or the User-Level Security Wizard (Tools menu, Security submenu, User-Level Security Wizard command). These utilities ship only with Access. Because of this, you must use Access to set up the initial elements of a secured system. Although you have full programmatic access to existing security through ADO or DAO, it's often easier to use Access to develop and maintain security in your solution.