Category Archives: Old Material
An ADO Command Factory for Stored Procedures
There are some technical and bureaucratic obstacles to using ADO command objects. Since using stored procedures can make a tremendous difference to your Access application, Burton Roberts supplies a simple way to get around the first problem. Recently, I read … Continue reading
An Access Explorer for SQL Server Tables
Rick Dobson follows up last month’s article with another tool for exploring SQL Server databases. Rick’s table explorer allows you to connect to any database, pull up any table in the database, and review or update the data in the … Continue reading
Advanced Data Shaping
Mike Gunderloy provides some examples of ADO’s SHAPE_APPEND statement in action, including how to synchronize child and parent Recordsets. Mike also introduces the SHAPE_COMPUTE statement. The SHAPE_APPEND command lets you work with hierarchical data (see my article, “Data Shaping: Handling … Continue reading
An ADO Tutorial: What is ADO?
In this article, Russell Sinclair provides a primer on what you need to know about ADO: what it is, why you should care, ADO’s relation to OLE DB, and a tour of the major objects in ADO. In order to … Continue reading
Active Data Objects
OLE DB is interesting, but you can’t get to it from Access. To make OLE DB accessible to VBA programmers, Microsoft has provided ADO. Michael provides an introduction to this new technology. Active Data Objects (ADO) are the gateway to … Continue reading