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:
'First, set a reference in your VB project to Microsoft ActiveX 'Data Objects Library 2.0 or above 'In the Declarations section of a module, enter the following: Dim Cnn As ADODB.Connection Dim Rst As ADODB.Recordset

Code: