DAO Object Model

Helen Feddema grew up in New York City. She was ready for computers when she was 12, but computers were not ready for her yet, so she got a B.S. in philosophy from Columbia and an M.T.S. in theological studies from Harvard Divinity School, while working at various office jobs. It was at HDS that she got her first computer, an Osborne, and soon computers were her primary interest. She started with word processing and spreadsheets, went on to learn dBASE, and did dBASE development for six years, part of this time as a corporate developer. After being laid off in a flurry of corporate downsizing, she started doing independent consulting and development, using dBASE, ObjectVision, WordPerfect and Paradox. Always looking for something new and better, Helen beta tested Access 1.0, and soon recognized that this was the database she had been looking for ever since Windows 3.0 was introduced and she saw the gap waiting to be filled by a great Windows database. Since then she has worked as a developer of Microsoft Office applications, concentrating on Access, Word, and Outlook. Helen coauthored Inside Microsoft Access, (New Riders, 1992), and wrote two books for Pinnacle's "The Pros Talk Access" series, Power Forms and Power Reports (1994). She also coauthored Access How-Tos for the Waite Group Press (1995), and more recently contributed to The Microsoft Outlook Handbook (Osborne-McGraw-Hill), Que's Special Edition: Using Microsoft Outlook 97 (1997), Office Annoyances (O'Reilly, 1997), and Outlook Annoyances (O'Reilly, 1998). She also contributed chapters to Que's Special Edition: Using Microsoft Project 98 (1997) and Teach Yourself Project (1998). Most recently, Helen co-authored Sybex' MCSD: Access 95 Study Guide (1998). She has also been a regular contributor to Pinnacle's Smart Access and Office Developer journals, Woody's Underground Office newsletter, PC Magazine's Undocumented Office and the MS Office and VBA Journal. She recently contributed articles on Menu Manager and Outlook Automation Access add-ins and Access-Word data merging to Smart Access, as well as writing the Access Archon column for the Woody's Office Watch e-zine. Helen is a big-time beta tester, sometimes having 7 or 8 betas running at once, mostly Microsoft, but with some from other vendors as well. She lives in the mid-Hudson area of New York state, with three cats and three computers. Helen maintains a Web page (www.ulster.net/~hfeddema) with a large selection of code samples concentrating on connecting Access, Outlook, Word and Excel. She is an MVP on the WOPR Lounge, a threaded discussion group devoted to Microsoft Office.

Preface 1. Introduction Early and Late Binding The Object Models for Working with Access The Visual Basic Dialects 2. DBEngine Object DBEngine Properties DBEngine Methods 3. Errors Collection and Error Object Errors Collection Properties Errors Collection Methods Error Object Properties 4. Workspaces Collection and Workspace Object Workspaces Collection Properties Workspaces Collection Methods Workspace Object Properties Workspace Object Methods 5. Databases Collection and Database Object Databases Collection Properties Databases Collection Methods Database Object Properties Database Object Methods 6. Containers Collection and Container Object Containers Collection Properties Containers Collection Methods Container Object Properties 7. QueryDefs Collection and QueryDef Object QueryDefs Collection Properties QueryDefs Collection Methods QueryDef Object Properties QueryDef Object Methods 8. Recordsets Collection and Recordset Object Recordsets Collection Properties Recordsets Collection Methods Recordset Object Properties Recordset Object Methods 9. Relations Collection and Relation Object Relations Collection Properties Relations Collection Methods Relation Object Properties Relation Object Methods 10. TableDefs Collection and TableDef Object TableDefs Collection Properties TableDefs Collection Methods TableDef Object Properties TableDef Object Methods 11. Groups Collection and Group Object Groups Collection Properties Groups Collection Methods Group Object Properties Group Object Methods 12. Users Collection and User Object Users Collection Properties Users Collection Methods User Object Properties User Object Methods 13. Fields Collection and Field Object Fields Collection Properties Fields Collection Methods Field Object Properties Field Object Methods 14. Parameters Collection and Parameter Object Parameters Collection Properties Parameters Collection Methods Parameter Object Properties 15. Indexes Collection and Index Object Indexes Collection Properties Indexes Collection Methods Index Object Properties Index Object Methods 16. Properties Collection and Property Object Properties Collection Properties Properties Collection Methods Property Object Properties A. Object Model Browser B. Object Model Browser Reference Index