Using Access 97 as an Automation Server

Access 97 exposes all of its application objects to other 32-bit, automation-enabled applications through the Access.Application.8 object. To use Access as an Automation server, you create in a module a reference to the Microsoft Access 97 type library, Msaccess.tlb—which is located in the Access folder, not in \Windows\System. Any member of the Office 97 suite and 32-bit Visual Basic 4+ can manipulate Access 97 Application objects, properties, and methods.

The extent to which developers will use Access 95 application objects instead of the Jet 3.5 database engine remains to be seen. Using the Jet 3.5 data access object to manipulate databases is much faster and consumes far fewer resources than launching ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.