Compact and Repair a User Level secured Access database

Category:
Database
Type:
Snippets
Difficulty:
Intermediate
Author:
Phil Fresle

Version Compatibility: Visual Basic 6

More information:
This code can be used to compact and repair an access database with user level security using the Microsoft Jet and Replication Objects Library (part of ADO).

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: