O'Reilly logo

Microsoft® Access VBA Programming for the Absolute Beginner by Michael Vine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 10DATABASE PROGRAMMING WITH ADO

With a basic knowledge of VBA programming, you can leverage the power of Microsoft’s ActiveX Data Objects (commonly referred to as ADO) to access and manage data sources such as Oracle, Microsoft SQL Server, Microsoft Access, and many others. In this chapter, I will show you how to connect to a remote Microsoft Access database; retrieve, update, add, and delete records using VBA; and I will explain the ADO application programming interface.

ADO OVERVIEW

For many years, Microsoft has implemented and supported a database programming architecture called ADO (ActiveX Data Objects), which is an object-based programming model that allows programmers in many Microsoft programming languages such as Visual C++, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required