Data Object (Class Module)
A class module for Excel or Access, that encapsulates a specific implementation SQL Server data:
Properties
Most properties are constants within the class, to separate the data interaction from the application
Methods
- Numerous public methods for invoking stored procedures to retrieve, add, delete, and update records
- Filter/Unfilter recordset
- Private methods for establishing/closing connections, verifying user access, verifying version
- Private method for correcting SQL strings containing single quotes
Right-click to Save Target As: CDBIRSData.txt