by Ron Weight (1 Submission)
Category: OLE/COM/DCOM/Active-X
Compatability: Visual Basic 5.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (3 Votes)
This is an Active-X DLL that simplifies the maintenance of Access and SQL databases by providing an interface for backing up, compressing, restoring, detach and attach (for SQL) functions.
Inputs
Inputs vary depending on the function selected. The sample or test program included shows all of the inputs (path to DB, path to restore, etc.)
Assumes
The code uses ADO 2.7, MS Jet & replication objects, MS Scripting (SCRRUN.DLL) and SQL DMO objects (SQLDMO.DLL) to do the maintenance functions. You should have these components installed on your computer before you can compile this DLL.
Code Returns
The DLL returns information via various events to the client application calling it. Most of the functions return a Boolean value to indicate if successful or not.