O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

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

Object Model

The SQL-DMO library’s object model, shown in Figure 23-1, contains all SQL Server/MSDE objects. SQL Server 2000/MSDE 2000 SQL-DMO library is more comprehensive than the library distributed with SQL Server 7/MSDE.

Figure 23-1. SQL-DMO object model

You can use the Microsoft Visual Basic for Application (VBA) editor’s object catalog to look up the different collections, objects, methods, and properties.

In this chapter, we are using the object SQLServer, which is the root object in the hierarchy and contains basic data for a given server. The SQLServer object’s Databases collection returns an object for every database created on ...

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