Connect to a Secure Access Database Using ADO

Category:
Database
Type:
Snippets
Difficulty:
Intermediate
Author:
Brad

Version Compatibility:

More information:
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.

Declarations:

Code: