* This is the most definitive book on the subject and has been the leading reference on ADO since its first release. * Covers all versions of ADO. * Covers related technologies, such as ADOX and ADOMD. * Supported by online samples in multiple languages. * Examines performance aspects of ADO.
All programmers working in database technology using Microsoft development tools will find this book useful. As a reference, it is suitable for beginners and experienced programmers alike. This is a great addition and complement to any other ADO manual, and its one you'll want to keep on the desk at all times. This informative guide provides a complete reference to the ADO API, covering all versions up to 2.8. Code samples are concise, and emphasis is placed on ADO techniques rather than the specific environments in which it may be used. Some of the book's highlights include: Coverage of related technologies, such as ADOX and ADOMD Online samples in multiple languages Examination of ADO performance aspects This is the most definitive book on the subject to date, and has been the leading reference on ADO since its first release. Please note: source code can be downloaded from the following URL: http://www.ipona.com/samples/
A comprehensive guide to programming for Access 2010 and 2007 Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements. With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications. Coverage Includes: Introduction to Microsoft Access 2010 New Features Upgrading and Converting to Access 2010 Macros in Access 2010 Using the VBA Editor VBA Basics Using VBA in Access Creating Classes in VBA Extending VBA with APIs Working with the Windows Registry Using DAO to Access Data Using ADO to Access Data Using SQL with VBA Using VBA to Enhance Forms Enhancing Reports with VBA Customizing the Ribbon Customizing the Office Backstage Working with Office 2010 Working with SharePoint Working with .NET Building Client-Server Applications with Access The Access 2010 Templates Access Runtime Deployment Database Security Access 2010 Security Features
A Programmer's Guide to ADO.NET in C# begins by taking readers through a fast-paced overview of C# and then delves into ADO.NET. Why should C# programmers use it instead of the existing technologies? What new functionality does it offer? The chapters that follow go through the details on each of the major Data Providers of the .NET platform (OleDb, SQL Server, and ODBC) that enable you to read and write data to the targeted database. These chapters also serve as a good reference for looking up detailed methods and properties for these data provider classes. Authors Chand and Gold also show C# programmers how to work with XML classes and how to integrate XML into the ADO.NET architecture. The book provides programmers with handy ideas about taking advantage of the VS.NET IDE and how you can tie your data to the myriad of powerful controls including the multi-faceted Data Grid. Finally, it goes through creating a guest book application for the Web so you can see how all the pieces fit together.
The architecture of ADO (ActiveX Data Objects), Microsoft's newest form of database communication, is simple, concise, and efficient. This indispensable reference takes a comprehensive look at every object, collection, method, and property of ADO for developers who want to get a leg up on this technology.
What is this book about? Its power and short learning curve have made Access Microsoft’s leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In this book, a crack team of programmers, including two Microsoft MVPs, shows you how to take control of Access 2003 or 2002 using VBA. You’ll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features. You’ll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server, and how to use VBA in Access to control and enhance other Office applications. What does this book cover? Here are some of the things you'll discover in this book: How to take advantage of the built-in Access object library, using Access commands and executing them from any Access toolbar What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data How to configure custom menus for your Access database applications Ways to transfer information between Access and Excel, Word, Outlook, and other Office programs How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code Who is this book for? This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access.
What is this book about? Excel 2003 VBA Programmer's Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal. The book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications for other users. The book starts with a primer chapter focused on bringing the readers up to speed with Excel and VBA. From there, the book expands to focus on major issues faced by advanced Excel users and developers. What does this book cover? In this book, you'll discover how to do the following: Set up applications and convert them to add-ins Package and distribute Excel applications Set up interaction with other Office applications and databases Program the VB Editor and use the Windows API Use VB6 and VB.NET with Excel Set up internationalization Advanced debugging and error handling techniques
What is this book about? Its power and short learning curve have made Access Microsoft’s leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In this book, a crack team of programmers, including two Microsoft MVPs, shows you how to take control of Access 2003 or 2002 using VBA. You’ll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features. You’ll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server, and how to use VBA in Access to control and enhance other Office applications. What does this book cover? Here are some of the things you'll discover in this book: How to take advantage of the built-in Access object library, using Access commands and executing them from any Access toolbar What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data How to configure custom menus for your Access database applications Ways to transfer information between Access and Excel, Word, Outlook, and other Office programs How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code Who is this book for? This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access.
For every developer who's uttered, "I wish I knew that before I started writing all this code!" this guide demonstrates how to save time, write less code, and build more powerful, data-driver solutions using Microsoft ActiveX Data Objects. CD contains code samples in VB, along with examples in Visual C++, and Visual J++.
Office 2002 is the next version (after Office 2000) of Microsoft's program suite that includes Word, Access, Outlook and Excel. The aim of 2002 is to take advantage of Office's core position within most business systems and make it the interface to business processes and web services. One of the most significant advances is the XML capability that has been added to Access and Excel, with the latter becoming the key to future Web Service integration and an essential part of any Office developer's skill set. -- Written by two active and popular members of the Excel community -- Includes coverage of all the new features including smart tags, pivot tables, and web components -- Examines all the new XML capabilities that 2002 brings to the Excel world