Data Object (Class Module)

A class module for Excel or Access, that encapsulates a specific implementation SQL Server data:


Most properties are constants within the class, to separate the data interaction from the application


  • 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

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License