Connect to a Secure Access Database Using ADO
A secure Access database is one which in which the database and its users, groups, and permissions are created and set via an .mdw file. This code shows you how to access a secure Access database via ADO. It provides a workaround for the bug described by the Microsoft knowledge base article at http://support.microsoft.com/support/kb/articles/Q229/7/41.ASP
Instructions: Copy the declarations and code below and paste directly into your VB project.