Access & DAO Object Models: The Definitive Reference

Overview

Each iteration of Windows has meant a corresponding improvement in the techniques used for transferring data among its applications. Today's leading technique is called Automation. It allows you to work directly with objects in an application's interface using their object models. But if you want to write code in a programming language, such as Visual Basic, in order to work with the apps that support Automation, you must understand the inner workings of an application's object model?or in the case of Microsoft's...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (12) from $1.99   
  • Used (12) from $1.99   
Close
Sort by
Page 1 of 2
Showing 1 – 10 of 12 (2 pages)
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since 2007

Feedback rating:

(10159)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Good
Light shelf wear and minimal interior marks. Millions of satisfied customers and climbing. Thriftbooks is the name you can trust, guaranteed. Spend Less. Read More.

Ships from: Auburn, WA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2014

Feedback rating:

(53)

Condition: Acceptable
Fair This item is listed as acceptable and has probably been well used. It could have considerable writing or highlighting throughout but is still usable and has been priced ... accordingly. Please do not buy if you are expecting a perfect copy. It has a couple more reads left before its time to be recycled. We ship within 1 business day and offer no hassle returns. Big Hearted Books shares its profits with schools, churches and non-profit groups throughout New England. Thank you for your support! Read more Show Less

Ships from: Sharon, MA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2009

Feedback rating:

(24022)

Condition: Good
Our feedback rating says it all: Five star service and fast delivery! We have shipped four million items to happy customers, and have one MILLION unique items ready to ship today!

Ships from: Toledo, OH

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$8.74
Seller since 2014

Feedback rating:

(3)

Condition: Good
2000 Paperback Good Connecting readers with great books since 1972. Used books may not include companion materials, some shelf wear, may contain highlighting/notes, and may not ... include cd-rom or access codes. Customer service is our top priority! Read more Show Less

Ships from: Palatine, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$11.36
Seller since 2014

Feedback rating:

(1)

Condition: Good
2000 Paperback Good Connecting readers with great books since 1972. Used books may not include companion materials, some shelf wear, may contain highlighting/notes, and may not ... include cd-rom or access codes. Customer service is our top priority! Read more Show Less

Ships from: Omaha, NE

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$17.95
Seller since 2014

Feedback rating:

(22)

Condition: Good
2000 Other Good.

Ships from: Pueblo West, CO

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$28.48
Seller since 2010

Feedback rating:

(971)

Condition: Like New
1565924355 Like New. Includes Unopened CD/DVD(s). Clean, Tight and Neat. Five star seller - Ships Quickly - Buy with confidence!

Ships from: Lake Arrowhead, CA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$31.17
Seller since 2014

Feedback rating:

(323)

Condition: Good
Possible retired library copy, some have markings or writing. May or may not include accessories such as CD or access codes.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$35.71
Seller since 2014

Feedback rating:

(323)

Condition: Like New
As new.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$49.53
Seller since 2010

Feedback rating:

(6)

Condition: Very Good
Very good 1 volume, please be aware of language, air mail shipment from Germany within 2-6 weeks, we deliver to any country-please ask us to enable delivery to your country! ... *****PLEASE NOTE: This item is shipping from an authorized seller in Europe. In the event that a return is necessary, you will be able to return your item within the US. To learn more about our European sellers and policies see the BookQuest FAQ section***** Read more Show Less

Ships from: Berlin, Germany

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 2
Showing 1 – 10 of 12 (2 pages)
Close
Sort by
Sending request ...

Overview

Each iteration of Windows has meant a corresponding improvement in the techniques used for transferring data among its applications. Today's leading technique is called Automation. It allows you to work directly with objects in an application's interface using their object models. But if you want to write code in a programming language, such as Visual Basic, in order to work with the apps that support Automation, you must understand the inner workings of an application's object model—or in the case of Microsoft's Access, its two object models.Microsoft Access is the bestselling stand-alone relational database program for Windows offering both power and ease of use. And in many respects, Microsoft has made Automation the centerpiece of its vision for application development. DAO Object Model: The Definitive Reference will guide you through the Access object models, allowing you, with the support of Automation, to reference the application components you want to manipulate. An understanding of the object models is essential for developers who work with data in Access tables, or who want to manipulate components of the Access interface from other Office apps. The Data Access Objects (DAO) model is used to write and read data in Access tables. The Access object model is used to manipulate forms, reports, queries, macros, and other components of the Access interface, including most of the commands by means of the DoCmd object.This book will include an introduction and a brief description of the differences between VBA (used in most Office applications) and VBScript (used in Outlook). This chapter will also cover Office utilities and add-ons helpful in writing and debugging code, such as the Object Browser, the Integrated Development Environment (IDE) for VBA and the Interactive Debugger for VBScript. The book will then be divided into two parts; one covering the Access Object Model and the other, the Data Access Objects. Each section will have a description of what the object represents; listings of properties, events, and methods; and one or more code samples illustrating its use in VBA and/or VBScript code. Each property, event, or method section will have an explanation of the language element, and many will have code samples (either VBA or VBScript) as well.This book will detail, to an advanced user or keen intermediate user, the Access object models and how they are used. It will be the reference guide VB developers reach for when working with data in Access tables, or for manipulating components of the Access interface from other Office applications.

Read More Show Less

Product Details

  • ISBN-13: 9781565924352
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 11/1/1999
  • Edition description: BK&CD ROM
  • Edition number: 1
  • Pages: 403
  • Product dimensions: 7.00 (w) x 9.19 (h) x 0.86 (d)

Meet the Author

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. Since that time, 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 sometimes beta tests seven or eight products 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 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.

Read More Show Less

Table of Contents

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 INDEX:

A[ Top ]
AbsolutePosition property, 178
Access
      to the Container object, 131
      to the Database object, 80
      to the DBEngine object, 25
      to the Error object, 43
      to the Field object, 294-295
      to the Group object, 273
      to the Index object, 330
      object models for working with, 6-11
      to the Parameter object, 321
      to the Property object, 342-343
      to the QueryDef object, 143
      to the Recordset object, 174
      to the Relation object, 230
      to the TableDef object, 243
      to the User object, 283
      to the Workspaces collection and Workspace object, 51
Access 97
      converting databases to Access 2000, 11
      data source type, 69
      Help errors in, 31
Access 2000
      Help errors in, 31, 35
      object model, 7, 128
Access Application object, SetOption method in, 40-41
Access code, displaying DBEngine properties, 19-20
Access custom database properties vs. Word, 98-101
Access databases, using OpenDatabase method for, 37
Access object model, 6
Access Screen object, 1
Access tables, creating, 240
Access VBA, creating databases from, 63
Access VBA code, 14-15
      for GetRows method, 214
      for OpenRecordset method, 116-117, 166
ActiveX Data Objects (ADO) object model, 9-11
AddNew method
      Recordset object, 202-203
      VBA code for, 202-203
ADO (see ActiveX Data Objects object model)
AllForms collection, 128
AllowZeroLength property
      Field object, 298
      read/write characteristics of, 298
AllPermissions property
      Container object, 133-134
      VBA code for, 134
AllPermissions return values
      for Container objects, 133-134
      for Document objects, 134
AllReports collection, 128
Append method
      Fields collection, 296-297
      Groups collection, 274-277
      Indexes collection, 331-332
      Properties collection, 344
      QueryDefs collection, 145-146
      Relations collection, 232
      TableDefs collection, 244-245
      Users collection, 284-285
      VBA code for, 53-54, 145-146, 232, 245, 275, 277, 284-285, 296-297, 331-332, 344
      Workspaces collection, 53-54
AppendChunk method
      Field object, 316-317
      VBA code for, 316-317
Application versions, 29-30
Arguments, assigning values to, 161, 340
Attributes intrinsic constants for Field objects, 299
Attributes property
      Field object, 299-300
      read/write characteristics of, 299
      Relation object, 233-234
      TableDef object, 247-248
      VBA code for, 248, 300
Auto list members, 5
Automation code, 1

B[ Top ]
Batch update, ODBCDirect workspaces, 193
BatchCollisionCount property, Recordset object, 179
BatchCollisions property, Recordset object, 179
BatchSize property, Recordset object, 179
Beginning of file (see BOF property)
BeginTrans method
      DBEngine object, 30
      VBA code for, 58-59
      Workspace object, 58-59
BOF property
      Move methods with, 180
      Recordset object, 180-181, 216
      VBA code for, 180-181
Bookmark property
      Recordset object, 178, 181-182
      VBA code for, 181-182
Bookmarkable property, Recordset object, 182

C[ Top ]
CacheSize property
      QueryDef object, 148-149
      Recordset object, 182
CacheStart property, Recordset object, 183
Cancel method
      QueryDef object, 159
      Recordset object, 203
CancelUpdate method
      Recordset object, 184, 203-204
      Type intrinsic constants for, 203
      VBA code for, 204
Cascading deletes, 207
Clone method, Recordset object, 204-205
Close method
      Database object, 95-96
      Outlook VBS code for, 96
      QueryDef object, 159
      Recordset object, 205
      VBA code for, 95
      Workspace object, 60
Clustered property, Index object, 333
cmdCopyQueryDef_Click event, 206
Code examples (see Access VBA code; Excel VBA code; Outlook VBS code; VBA code; VBS code; Word VBA code)
Coding, assistance in, 5
CollatingOrder property
      Database object, 82-84
      dstlocale named constants to set, 31-32
      Field object, 300-302
      read/write characteristics of, 301
      VBA code for, 83-84, 301-302
      VBS code for, 84
CollatingOrder property intrinsic constants, 300-301
CollatingOrder values, 83
Collection methods
      Containers, 133
      Databases, 82
      Errors, 45
      Fields, 296-298
      Groups, 274-278
      Indexes, 331-333
      Parameters, 320, 323
      Properties, 344-345
      QueryDefs, 145-148
      Recordsets, 175-176
      Relations, 232-233
      TableDefs, 244-247
      Users, 284-286
      Workspaces, 53-54
Collection numbering, 44
Collection properties
      Databases, 80-82
      Errors, 44
      Fields, 295-296
      Groups, 273-274
      Indexes, 330-331
      Parameters, 320, 322
      Properties, 343
      QueryDefs, 143-144
      Recordsets, 175
      Relations, 230-232
      Users, 283-284
      Workspaces, 51-53
Collections, persistent, 82
CommitTrans method
      DBEngine object, 30
      VBA code for, 58-59
      Workspace object, 60
CompactDatabase method
      DBEngine object, 31-35
      dstlocale named constants for, 31-32
      options named constants for, 32-33
      VBA code for, 33-35
Compile errors, after converting Access 97 database to Access 2000, 11
ConflictTable property
      TableDef object, 248-249
      VBA code for, 248-249
Connect intrinsic constants for CreateDatabase method, 61-62
Connect property
      Database object, 84-85
      databasetype argument settings, 85, 149-150
      QueryDef object, 149-150
      TableDef object, 249-251
      VBA code for, 150, 250-251
Connect property arguments, 249
Connection objects, opening on ODBC data source, 68
Connection property
      Database object, 85-86
      Recordset object, 183
constants (see Connect intrinsic constants; Intrinsic constants; Lockedits intrinsic constants; Named constants; Permissions property intrinsic constants; RecordStatus intrinsic constants)
Container object properties, 130-131, 133-139
      AllPermissions, 133-134
      Inherit, 134-135
      Name, 135-136
      Owner, 136
      Permissions, 136-138
      UserName, 138-139
Container objects
      access to, 131
      AllPermissions return values for, 133-134
      in Database Containers collection, 127-128
      Documents collections in, 128
      Outlook VBS code for, 129-130
      Permissions property intrinsic constants for, 137
      VBA code for, 127, 129
Containers collection and Container object, 126-139
Containers collection methods, 133
Containers collections
      in the DAO object model, 126
      members of, 130
Containers object properties, 131-132
      Count, 131-132
      Item, 132
Control Panel, 356
CopyQueryDef method, Recordset object, 206-207
Count property
      Containers object, 131-132
      Databases collection, 80-81
      Errors collection, 44
      Fields collection, 295
      Groups collection, 273
      Indexes collection, 330
      Parameters collection, 322
      Properties collection, 343
      QueryDefs collection, 143-144
      Recordsets collection, 175
      Relations collection, 230-231
      TableDefs object, 243
      Users collection, 283
      VBA code for, 51-52, 81, 131-132, 231, 283, 295
      Workspaces collection, 51-52
Create Enum Select Code option, 361
Create Model Wizard dialog, 355-356
CreateDatabase method
      Connect intrinsic constants for, 61-62
      DBEngine object, 35, 360
      Options intrinsic constants for, 62
      Outlook VBS code for, 63-64
      VBA code for, 62-63
      Workspace object, 60-64
CreateField method
      Index object, 339
      Relation object, 237-238
      TableDef object, 262-263
      Type intrinsic constants for, 262-263
      VBA code for, 237-238
CreateGroup method
      User object, 288-290
      VBA code for, 65-66, 288-290
      Workspace object, 64-66
CreateIndex method, 247
      TableDef object, 263-265
      VBA code for, 264-265
CreateObject function, 12, 21, 359
CreateProperty method
      Database object, 97-101
      Field object, 317-318
      Index object, 340
      QueryDef object, 159-161
      TableDef object, 265-267
      Type intrinsic constants for, 97-98, 160, 266-267
      VBA code for, 101, 161, 267
CreateQueryDef method, Database object, 102-103
CreateRelation method
      Database object, 104-106
      VBA code for, 105-106
CreateTableDef method
      Database object, 106-109
      Outlook VBS code for, 108-109
      VBA code for, 108
CreateUser method
      Group object, 279-280
      Workspace object, 66-67
CreateWorkspace method
      DBEngine object, 35-36, 48
      Type intrinsic constants for, 36
CurrentDb method, 253
Custom database properties, Word vs. Access, 98-101

D[ Top ]
DAO 3.5 object library, setting a reference to, 120
DAO Container objects, 1
DAO object model, 6-9
      Containers collections in, 126
      Databases collections in, 78
      Errors collection and Error object in, 42
      Fields collections in, 293
      Groups and Users collections in, 271
      Indexes collections in, 329
      for Jet workspaces, 8, 18
      for ODBCDirect workspaces, 9, 19
      Parameters collections in, 319
      QueryDefs collections in, 140
      Recordsets collections in, 171
      Relations collections in, 104, 226
      TableDefs collections in, 239
      Users collections in, 281
      Workspaces collection and Workspace object in, 48
DAO object variables, early binding of, 120, 166
Data processing, suspending, 36
Data Source Name (see DSN)
Data typing
      explicit, 2
      generic vs. specific, 3
      variant, 2
Database Containers collection, Container objects in, 127-128
Database object collections, 78-79
Database object methods, 79-80, 95-125
      Close, 95-96
      CreateProperty, 97-101
      CreateQueryDef, 102-103
      CreateRelation, 104-106
      CreateTableDef, 106-109
      Execute, 109-111
      MakeReplica, 111-112
      NewPassword, 112-113
      OpenRecordset, 113-122
      PopulatePartial, 122-123
      Synchronize, 124-125
Database object properties, 79, 82-95
      CollatingOrder, 82-84
      Connect, 84-85
      Connection, 85-86
      DesignMasterID, 86-87
      Name, 87-88-
      QueryTimeout, 88
      RecordsAffected, 88-89
      Replicable, 89-91
      ReplicaBool, 90
      ReplicaID, 91-92
      ReplicationConflictFunction, 92-93
      Transactions, 93
      Updatable, 93
      Version, 94-95
      V1xNullBehavior, 93-94
Database objects
      access to, 80, 354
      as children of DBEngine, 360
      referencing, 78
      retrieving, 81-82
Database variables, auto list members for, 5
Database window, creating TableDefs in, 107
Databases
      converted into Design Master, 91
      creating, 62
      navigating to, 353
      removing, 77
      replicated, 89, 256
      replicating, 61
      replicating in a remote folder, 112
      saved, 126
      selecting for DSN, 71
Databases collection and Database object, 77-125
Databases collection methods, 82
Databases collection properties, 80-82
      Count, 80-81
      Item, 81-82
Databases collections
      in the DAO object model, 78
      and the System database, 80
Databases Container, Permissions property (intrinsic constants for), 137
Databasetype argument settings, Connect property, 85, 149-150, 250
DataUpdatable property, Field object, 302
DateCreated property
      QueryDef object, 150-151
      Recordset object, 183
      TableDef object, 251
      VBA code for, 150-151, 183, 251
DBEngine objects, 17-42
      access to, 25
      Database object as a child of, 360
      global members of, 25
      instantiating new, 12
      methods of, 24, 30-41
      properties, 26-30
      Word VBA code to access, 22
DBEngine properties, 23-24
      Access code to display, 19-20
      Excel VBA code to display, 20
dbOpenTable constant, 4
dbRunAsync option, 158-159, 195, 203
dbVersion constants, 33
DCount function, 246
Debug window, listings to, 83, 88, 95, 103, 127, 142, 161, 166, 191, 248, 259, 300-301, 307, 326, 344
DefaultCursorDriver property
      intrinsic constants, 54-55
      VBA code for, 55
      Workspace object, 54-55, 203
DefaultPassword property, DBEngine object, 26
DefaultType property
      DBEngine object, 26
      values of, 26
DefaultUser property
      characters not permitted in strings of, 27
      DBEngine object, 26-27
DefaultValue property, Field object, 302-303
Delete method
      Fields collection, 297-298
      Groups collection, 278
      Indexes collection, 332-333
      Properties collection, 345
      QueryDefs collection, 147
      Recordset object, 207-208
      Relations collection, 232-233
      TableDefs collection, 246
      Users collection, 285
      VBA code for, 147, 207-208, 232-233, 246, 297-298, 332-333, 345
      Workspaces collection, 54
Deletes, 207
Description property, Error object, 45-46
Design Master
      database converted into, 91
      new, showing the GUID, 87
      replicating, 86
Design view, query with parameters in, 320
DesignMasterID property, Database object, 86-87
Direction intrinsic constants, 323
Direction property, Parameter object, 323
DistinctCount property, Index object, 334
DLL Access Violation, error message, 357
DoCmd objects, 1
Document objects, extra AllPermissions return values for, 134
DSN, 69-71
      creating new, 69-70
      naming, 70
      selecting database for, 71
dstlocale named constants, 31-32
Dynamic Data Exchange (DDE), 1

E[ Top ]
Early binding, 4-5
      of DAO object variables, 120, 166
      object references in, 5
      (see also late binding)
Edit method, Recordset object, 208
EditMode property, Recordset object, 184-185, 203
End of file (see EOF property)
Enumerations in Object Model Browser, 360-364
EOF property
      Move methods with, 180
      Recordset object, 185, 216
      VBA code for, 185
Error handler, 290
Error messages
      ActiveX component can't create object, 20
      after converting Access 97 database to Access 2000, 11
      DLL Access Violation, 357
      Invalid Operation, 219
      Item not found in this collection, 147, 202
      Method not applicable for this object, 49
      Method or data member not found, 90
      Object already exists, 102
      Object invalid or no longer set, 95
      Operation is not supported for this type of object, 86, 149
      Table already exists, 244
Error object properties, 43, 45-47
      Description, 45-46
      HelpContext, 46
      HelpFile, 46-47
      Number, 47
      Source, 47
Error objects, access to, 43
Error properties, message box displaying, 46
Errors collection and Error object, 42-47
      in the DAO object model, 42
Errors collection methods, 45
Errors collection properties, 43-44
Example code (see Access VBA code; Excel VBA code; Outlook VBS code; VBA code; VBS code; Word VBA code)
Excel ISAM formats, Windows 98 Registry Editor, 29
Excel VBA code
      to display DBEngine properties, 20
      for OpenRecordset method, 117-119
Exchange intrinsic constants, Synchronize method, 124
Execute method
      Database object, 109-111
      Options intrinsic constants for, 162
      Outlook VBS code for, 111, 163-164
      QueryDef object, 162-164
      VBA code for, 110-111, 162-163
Explorer objects, 1
Externally Creatable Objects dialog, 359

F[ Top ]
Field object methods, 294, 316-318
      AppendChunk, 316-317
      CreateProperty, 317-318
      GetChunk, 318
Field object properties, 294, 298-315
      AllowZeroLength, 298
      Attributes, 299-300
      CollatingOrder, 300-302
      DataUpdatable, 302
      DefaultValue, 302-303
      FieldSize, 303
      ForeignName, 303-305
      Name, 305-306
      OrdinalPosition, 306
      OriginalValue, 306
      Properties, 306-307
      Required, 307-308
      Size, 308-309
      SourceField, 309-310
      SourceTable, 310-311
      Type, 311-312
      ValidateOnSet, 313
      ValidationRule, 313-314
      ValidationText, 314-315
      Value, 315
      VisibleValue, 315
Field objects
      access to, 294-295
      Attributes intrinsic constants for, 299
      Properties collection of, 10
      in Recordset objects, 313
      referencing, 237, 292
FieldAttributeEnum enumeration, 299
Fields collection and Field object, 292-318
Fields collection methods, 293, 296-298
      Append, 296-297
      Delete, 297-298
      Refresh, 298
Fields collection properties, 293, 295-296
      Count, 295
      Item, 296
Fields collections, DAO object model, 293
Fields property, Index object, 336
FieldSize property, Field object, 303
Files (see BOF property; EOF property)
FillCache method, Recordset object, 209-210
Filter property
      Recordset object, 186-187
      VBA code for, 186
Find Parents option, 360
Find Paths to Object option, 360
FindFirst method, Recordset object, 210-211
FindLast method, Recordset object, 211-212
FindNext method, Recordset object, 212-213
FindPrevious method, Recordset object, 213-214
Flag values, 368
Foreign property, Index object, 335-336
ForeignName property, Field object, 303-305
ForeignTable property, Relation object, 234

G[ Top ]
GetChunk method, Field object, 318
GetObject function, 12
GetRows method, Recordset object, 214-216
Global view, 370
Group object methods, 279-280
Group object properties, 278-279
Group objects
      access to, 273
      members of, 272
      retrieving, 274
Groups and Users collections, DAO object model, 271
Groups collection and Group object, 271-280
Groups collection methods, 272, 274-278
      Append, 274-277
      Delete, 278
      Refresh, 278
Groups collection properties, 272-274
      Count, 273
      Item, 273-274

H[ Top ]
HelpContext property, Error object, 46
HelpFile property, Error object, 46-47

I[ Top ]
Idle method, DBEngine object, 36-37
IgnoreNulls property, Index object, 336
IISAM database formats, 333
Imported from Access category, 74
Index object methods, 329, 339-340
      CreateField, 339
      CreateProperty, 340
Index object properties, 329, 333-339
      Clustered, 333
      DistinctCount, 334
      Fields, 335
      Foreign, 335-336
      IgnoreNulls, 336
      Name, 336-337
      Primary, 337-338
      Required, 338-339
      Unique, 339
Index objects
      access to, 330
      VBA code for, 329-330
Index property, Recordset object, 187
Indexes collection and Index object, 328-340
Indexes collection methods, 328-329, 331-333
      Append, 331-332
      Delete, 332-333
      Refresh, 333
Indexes collection properties, 328, 330-331
      Count, 330
      Item, 331
Indexes collections, DAO object model, 329
Inherit property
      Container object, 134-135
      VBA code for, 135
Inherited property, Property object, 346-347
IniPath property
      DBEngine object, 27-28
      Word VBA code for, 28
Inspector objects, 1
Installable Indexed Sequential Access Method (see IISAM database formats)
Installation's startup dialog, 355
Instantiating a new or existing object, 358
Intrinsic constants (see Attributes intrinsic constants; CollatingOrder property intrinsic constants; Connect intrinsic constants; Direction intrinsic constants; Exchange intrinsic constants; Lockedits intrinsic constants; Options intrinsic constants; Permissions property intrinsic constants; Prepare setting intrinsic constants; RecordStatus intrinsic constants; Relations Attributes intrinsic constants; TableDef Attributes intrinsic constants; Type intrinsic constants; UpdateOptions intrinsic constants)
ISAM driver settings, 29
IsolateODBCTrans property, Workspace object, 55-56
Item property
      Containers object, 132
      Databases collection, 81-82
      Errors collection, 44
      Fields collection, 296
      Groups collection, 273-274
      Indexes collection, 331
      Parameters collection, 322-323
      Properties collection, 343
      QueryDefs collection, 144
      Recordsets collection, 175
      Relations collection, 231-232
      TableDefs object, 243-244
      Users collection, 283-284
      Workspaces collection, 52-53

J[ Top ]
Jet DAO, 17-18
      versions of, 29-30, 94
Jet databases, opening, 73
Jet workspaces, DAO object model for, 8, 18
Join relationship, 229
Join Type button, 227
Joint Properties dialog, modifying a join relationship, 229

K[ Top ]
KeepLocal property
      QueryDef object, 151
      setting to ""T,"" 151, 251
      TableDef object, 251-252
      VBA code for, 151, 252

L[ Top ]
LastModified property, Recordset object, 187-188
LastUpdated property
      QueryDef object, 151-152
      Recordset object, 188-189
      TableDef object, 252-253
      VBA code for, 152, 188-189, 253
Late binding, 2-5
      VBA code using, 3-4
      (see also early binding)
Local tables, 256
Local view, 369
Lockedits intrinsic constants for OpenRecordset method, 115, 165-166, 220-221, 269-270
LockEdits property, Recordset object, 189
Lockedits values/settings, 189
Locking, optimistic, 189
LoginTimeout property
      DBEngine object, 28
      VBA code for, 57
      Workspace object, 56
LogMessages property, QueryDef object, 152

M[ Top ]
Make Data File button, 355-356
Make Model button, 356
MakeReplica method
      Database object, 111-112
      VBA code for, 112
MaxRecords property, QueryDef object, 153
Methods
      BeginTrans, 30
      CommitTrans, 30
      CompactDatabase, 31-35
      CreateDatabase, 35
      CreateWorkspace, 35-36
      DBEngine object, 30-41
      Idle, 36-37
      OpenDatabase, 37
      RegisterDatabase, 38-39
      RepairDatabase, 39-40
      Rollback, 40
      SetOption, 40-41
      (see also Collection methods; Object methods)
Microsoft Access driver, selecting for new DSN, 70
Microsoft Object Browser (see Object Browser)
Microsoft products, Jet versions of, 94
Models (see Object models)
Move method
      with BOF and EOF, 180
      Recordset object, 216-217
MoveFirst method, Recordset object, 217
MoveLast method, Recordset object, 217-218
MoveNext method, Recordset object, 218
MovePrevious method, Recordset object, 218
MsgBox functions, 96, 129
MSysRepInfo table
      DesignMasterID property stored in, 86
      ReplicaID property stored in, 92
Multiuser environments, 37, 147, 278, 286, 298, 345

N[ Top ]
Name property
      altering, 36
      Container object, 135-136
      Database object, 87-88
      Field object, 305-306
      Group object, 278
      Index object, 336-337
Name property ([_Fi_]continued )
      Parameter object, 324
      Property object, 347
      QueryDef object, 153-154
      read/write characteristics of, 305
      Recordset object, 190
      Relation object, 235
      TableDef object, 253-254
      User object, 286
      VBA code for, 88, 135-136, 153-154, 190, 253-254, 278, 286, 305-306, 336-337
      Workspace object, 56-57
Named constants (see dstlocale named constants; Options named constants)
Naming rules, 56, 153, 286, 347
NewPassword method
      Database object, 112-113
      User object, 290-291
      VBA code for, 113, 290-291
NextRecordset method, Recordset object, 218-219
NoMatch property, Recordset object, 190-191, 210, 212
Nulls
      treatment of records with, 336
      (see also IgnoreNulls property)
Number property, Error object, 47

O[ Top ]
Object Browser, 351-352, 360
Object data type, 2, 4
Object hierarchies, 353
Object Linking and Embedding (OLE), 1
      servers and clients, 1
Object methods
      Database, 95-125
      Field, 316-318
      Group, 279-280
      Index, 339-340
      QueryDef, 159-169
      Recordset, 200-225
      Relation, 237-238
      TableDef, 262-270
      User, 288-291
      Workspace, 58-76
Object Model Browser, 351-364
      enumerations in, 360-364
      icons used by, 368-369
      installing, 353-357
      introduction, 1-16
      menu options, 365-368
      reference, 365-370
      uninstalling, 356
      using, 358-364
Object models, 1-2
      Access, 6
      accessing, 358
      ActiveX Data Objects (ADO), 9-11
      DAO, 6-9
      for working with Access, 6-11
Object properties
      Container, 133-139
      Containers, 131-132
      Database, 82-95
      Error, 45-47
      Field, 298-315
      Group, 278-279
      Index, 333-339
      Parameter, 320, 323-327
      Property, 346-349
      QueryDef, 148-159
      Recordset, 176-200
      Relation, 233-236
      TableDef, 247-261
      TableDefs, 243-244
      User, 286-288
      Workspace, 54-58
Objects
      instantiating new or existing, 358
      persistent, 49, 175
ODBC Data Source Administrator, 38, 69
ODBC data sources
      and the Clustered property, 333
      opening connection objects on, 68
ODBCDirect DAO, 17, 19
ODBCDirect workspaces, 54
      batch update for, 193
      DAO object model for, 9, 19
ODBCTimeout property
      overwriting QueryTimeout property, 88
      QueryDef object, 154
Office 2000, 2
OLE Automation, 1
OLEView, 351-352
One-to-many relationship, 228
Open Database Connectivity (ODBC), 1
Open event, 121
Open Object Model dialog, 358
OpenConnection method, 54
      for non-Access databases, 71
      Options intrinsic constants for, 68-69
      VBA code for, 71-72
      Workspace object, 68-72
OpenDatabase method, 54
      DBEngine object, 37
      Options intrinsic constants for, 73
      Outlook VBS code for, 74-76
      for a standard Access database, 37
      VBA code for, 73
      Workspace object, 72-76
OpenRecordset method
      Access VBA code for, 116-117, 166
      Database object, 113-122
      Excel VBA code for, 117-119
      Lockedits intrinsic constants for, 115, 165-166, 220-221, 269-270
      Options intrinsic constants for, 114-115, 165, 220, 268-269
      Outlook VBS code for, 121-122, 168-169
      QueryDef object, 164-169
      Recordset object, 219-222
      TableDef object, 268-270
      Type intrinsic constants for, 114, 164, 219, 268
      VBA code for, 221-222, 270
      Word VBA code for, 120-121, 166-168
Optimistic locking, 189
Options intrinsic constants, 110
      for CreateDatabase method, 62
      for Execute method, 162
      for OpenConnection method, 68-69
      for OpenDatabase method, 73
      for OpenRecordset method, 114-115, 165, 220, 268-269
Options named constants
      for CompactDatabase method, 32-33
OrdinalPosition property
      Field object, 306
      read/write characteristics of, 306
OriginalValue property, Field object, 306
Outlook 2000, using VBA code with, 96, 168
Outlook NameSpace, 1
Outlook VBS
      creating databases from, 62
      imported contact, 74
      using the DAO object model from, 63
Outlook VBS code, 15
      for Close method, 96
      for Container objects, 129-130
      for CreateDatabase method, 63-64
      for CreateTableDef method, 108-109
      for Execute method, 111, 163-164
      for GetRows method, 215
      to import data into a listbox on an Outlook form, 23
      for OpenDatabase method, 74-76
      for OpenRecordset method, 121-122, 168-169
Owner property, Container object, 136

P[ Top ]
Parameter object properties, 320, 323-327
      Direction, 323
      Name, 324
      Properties, 324-325
      Type, 325-326
      Value, 326
Parameter objects
      access to, 321
      VBA code for, 320-321
Parameters collection and Parameter object, 319-3287
Parameters collection methods, 320, 323
      Refresh, 323
Parameters collection properties, 320, 322
      Count, 322
      Item, 322-323
Parameters collections, DAO object model, 319
Parameters dialog, 319
Partial replicas, relation used to populate, 236
PartialReplica property
      Relation object, 235-236
      VBA code for, 235-236
Pass-through queries, 84, 157
Password property
      User object, 286-288
      VBA code for, 287-288
Passwords, changing and clearing, 287
PercentPosition property
      Recordset object, 191-192
      VBA code for, 191-192
Performance, effects of early and late binding, 5
Permissions
      access, 66
      from VBA code, 65
Permissions property
      Container object, 134, 136-138
      VBA code for, 138
Permissions property intrinsic constants
      for Container objects, 137
      for the Databases Container, 137
      for the Tables Container, 137
Personal identifier (see PID properties)
PID property
      Group object, 278-279
      User object, 288
PopulatePartial method
      Database object, 122-123
      VBA code for, 123
Prepare property, QueryDef object, 154
Prepare setting intrinsic constants, QueryDef object, 154
Primary property
      Index object, 337-338
      VBA code for, 338
Properties
      DBEngine object, 26-30
      DefaultPassword, 26
      DefaultType, 26
      DefaultUser, 26-27
      IniPath, 27-28
      LoginTimeout, 28
      referencing, 341
      SystemDB, 29
      Version, 29-30
      (see also Collection properties; Object properties)
Properties collection
      of a Field object, 10
      members of, 342
Properties collection and Property object, 341-349
Properties collection methods, 344-345
      Append, 344
      Delete, 345
      Refresh, 345
Properties collection properties, 343
      Count, 343
      Item, 343
Properties property
      Field object, 306-307
      Parameter object, 324-325
      VBA code for, 307, 324-325
Property object properties, 346-349
      Inherited, 346-347
      Name, 347
      Type, 347-348
      Value, 348-349
Property objects
      access to, 342-343
      members of, 342
      referencing, 341

Q[ Top ]
Queries
      pass-through, 84, 157
      saved, 114
      stored action, 110
      structure of, 140
      temporary, 145
Query Designer interface, 319
QueryDef object
      Prepare setting intrinsic constants for, 154
      VBA code for, 142-143
QueryDef object methods, 142, 159-169
      Cancel, 159
      Close, 159
      CreateProperty, 159-161
      Execute, 162-164
      OpenRecordset, 164-169
QueryDef object properties, 141-142, 148-159
      CacheSize, 148-149
      Connect, 149-150
      DateCreated, 150-151
      KeepLocal, 151
      LastUpdated, 151-152
      LogMessages, 152
      MaxRecords, 153
      Name, 153-154
      ODBCTimeout, 154
      Prepare, 154
      RecordsAffected, 154-155
      Replicable, 155-157
      ReplicableBool, 157
      ReturnsRecords, 157
      SQL, 157-158
      StillExecuting, 158
      Type, 158-159
      Updatable, 159
QueryDef objects, access to, 143
QueryDefs collection in the DAO object model, 140
QueryDefs collection and QueryDef object, 140-169
QueryDefs collection methods, 141, 145-148
      Append, 145-146
      Delete, 147
      Refresh, 147-148
QueryDefs collection properties, 141, 143-144
      Count, 143-144
      Item, 144
QueryTimeout property
      Database object, 88
      overwritten by ODBCTimeout property, 88

R[ Top ]
Random numbers, 303
Read Registry button, 355
RecordCount property
      Recordset object, 187, 192
      TableDef object, 254
      VBA code for, 192, 254
RecordsAffected property, 88-89
      Database object, 88-89
      QueryDef object, 154-155
      VBA code for, 89, 155
Recordset method, summary, 200-201
Recordset object methods, 173-174, 200-225
      AddNew, 202-203
      Cancel, 203
      CancelUpdate, 184, 203-204
      Clone, 204-205
      Close, 205
      CopyQueryDef, 206-207
      Delete, 207-208
      Edit, 208
      FillCache, 209-210
      FindFirst, 210-211
      FindLast, 211-212
      FindNext, 212-213
      FindPrevious, 213-214
      GetRows, 214-216
      Move, 216-217
      MoveFirst, 217
      MoveLast, 217-218
      MoveNext, 218
      MovePrevious, 218
      NextRecordset, 218-219
      OpenRecordset, 219-222
      Requery, 193, 222-223
      Seek, 211, 223-224
      Update, 184, 224-225
Recordset object properties, 172-173, 176-200
      AbsolutePosition, 178-179
      BatchCollisionCount, 179
      BatchCollisions, 179
      BatchSize, 179
      BOF, 180-181, 216
      Bookmark, 178, 181-182
      Bookmarkable, 182
      CacheSize, 182
      CacheStart, 183
      Connection, 183
      DateCreated, 183
      EditMode, 184-185, 203
      EOF, 185, 216
      Filter, 186-187
      Index, 187
      LastModified, 187-188
      LastUpdated, 188-189
      LockEdits, 189
      Name, 190
      NoMatch, 190-191, 210, 212
      PercentPosition, 191-192
      RecordCount, 187, 192
      RecordStatus, 192-193
      Restartable, 193-194
      Sort, 194-195
      StillExecuting, 195
      Transactions, 195-196
      Type, 196-197
Recordset object properties ([_Fi_]continued )
      Updatable, 197-198
      UpdateOptions, 198
      ValidationRule, 198-199
      ValidationText, 200
Recordset objects
      access to, 174, 361
      creating, 359
      duplicating, 204
      Field objects in, 313
      parents of, 361
      properties of, 176-178
      referencing, 172
Recordset types
      dynaset, 191-192, 196, 217
      forward-only, 192, 196
      snap-shot, 116, 191-192, 196, 217
      table, 120, 197, 211, 328
      updatable, 189
      uses of, 115-116, 201
Recordsets collection and Recordset object, 170-225
Recordsets collection methods, 175-176
Recordsets collection properties, 175
      Count, 175
      Item, 175
Recordsets collections
      in the DAO object model, 171
      members of, 172
RecordsetTypeEnum, members of, 362-363
RecordStatus intrinsic constants, 193
RecordStatus property, Recordset object, 192-193
References dialog, 5-6
References option, 5
Refresh method
      Containers collection, 133
      Databases collection, 82
      Errors collection, 45
      Fields collection, 298
      Groups collection, 278
      Indexes collection, 333
      Parameters collection, 323
      Properties collection, 345
      QueryDefs collection, 147-148
      Recordsets collection, 175-176
      Relations collection, 233
      TableDefs collection, 247
      Users collection, 286
      VBA code for, 133, 148
      Workspaces collection, 54
RefreshLink method, TableDef object, 270
RegisterDatabase method
      DBEngine object, 38-39
      VBA code for, 38-39
Registry option button, 355
Relation Attributes return values/settings, 234
Relation object methods, 230, 237-238
      CreateField, 237-238
Relation object properties, 230, 233-236, 304
      Attributes, 233-234
      ForeignTable, 234
      Name, 235
      PartialReplica, 235-236
      Table, 236
Relation objects
      access to, 230
      appending, 104
      referencing, 104
      retrieving, 231-232
      VBA code for, 227
Relations Attributes intrinsic constants, 104-105
Relations collection and Relation object, 226-238
Relations collection methods, 230, 232-233
      Append, 232
      Delete, 232-233
      Refresh, 233
Relations collection properties, 229-232
      Count, 230-231
      Item, 231-232
Relations collections in the DAO object model, 104, 226
Relationship join types, 229
Relationships window
      creating new relationship in, 104, 226, 228
      one-to-many relationship in, 228
Remote folder, replicating a database in, 112
RepairDatabase method
      DBEngine object, 39-40
      VBA code for, 39-40
Replica filters, changing, 123
Replicable choice, when creating new table, 255-256
Replicable property
      Database object, 89-91
      QueryDef object, 155-157
      setting to ""T,"" 90, 156, 255
      TableDef object, 255-257
      VBA code for, 90-91, 156-157, 256-257
ReplicableBool property
      QueryDef object, 157
      TableDef object, 257
ReplicaBool property, Database object, 90
ReplicaFilter property
      TableDef object, 257-258
      VBA code for, 258
ReplicaFilter return value/settings, 257-258
ReplicaID property
      Database object, 91-92
      stored in the MSysRepInfo table, 92
      VBA code for, 91-92
Replicated databases, 256
      synchronizing, 123
Replication Manager, 124
ReplicationConflictFunction property, Database object, 92-93
Requery method
      Recordset object, 193, 222-223
      VBA code for, 222-223
Required property
      Field object, 307-308
      Index object, 338-339
      read/write characteristics of, 308
Restartable property
      Recordset object, 193-194
      VBA code for, 193-194
ReturnsRecords property, QueryDef object, 157
Rollback method
      DBEngine object, 40
      VBA code for, 58-59
      Workspace object, 76
Runtime errors (see Error messages)

S[ Top ]
Saved queries, 114
Seek method
      Recordset object, 211, 223-224
      VBA code for, 223-224
SetOption method
      in the Access Application object, 40-41
      DBEngine object, 40-41
      VBA code for, 40-41
setup.exe, 353
Show Origins option, 360
Size property
      Field object, 308-309
      read/write characteristics of, 308
      VBA code for, 309
Sort property
      Recordset object, 194-195
      VBA code for, 194-195
Source property
      Error object, 47
SourceField property
      Field object, 309-310
      read/write characteristics of, 309-310
      VBA code for, 310
SourceTable property
      Field object, 310-311
      read/write characteristics of, 309-310
SourceTableName property
      TableDef object, 259
      VBA code for, 259
SQL property
      QueryDef object, 157-158
SQLExecDirect function, 154
SQLPrepare function, 154
Startup dialog, 355
StillExecuting property
      QueryDef object, 158
      Recordset object, 195
Stored action queries, 110
String variables, 3
Synchronize method
      Database object, 124-125
      Exchange intrinsic constants for, 124
      VBA code for, 124-125
System database, 80
SystemDB property
      DBEngine object, 29

T[ Top ]
Table property
      Relation object, 236
TableDef Attributes intrinsic constants, 107, 247-248
TableDef object methods, 241, 262-270
      CreateField, 262-263
      CreateIndex, 263-265
      CreateProperty, 265-267
      OpenRecordset, 268-270
      RefreshLink, 270
TableDef object properties, 241, 247-261
      Attributes, 247-248
      ConflictTable, 248-249
      Connect, 249-251
      DateCreated, 251
      KeepLocal, 251-252
      LastUpdated, 252-253
      Name, 253-254
      RecordCount, 254
      Replicable, 255-257
      ReplicableBool, 257
      ReplicaFilter, 257-258
      SourceTableName, 259
      Updatable, 259-260
      ValidationRule, 260-261
      ValidationText, 261
TableDef objects
      access to, 243
      VBA code for, 242-243
TableDefs collection and TableDef object, 239-270
TableDefs collection methods, 244-247
      Append, 244-245
      Delete, 246
      Refresh, 247
TableDefs collections
      in the DAO object model, 239
      members of, 240-241
TableDefs object properties, 243-244
      Count, 243
      Item, 243-244
Tables Container, Permissions property (intrinsic constants for), 137
Temporary queries, 145
Timeouts (see LoginTimeout property)
Tools menu, 5
Transactions property
      Database object, 93
      Recordset object, 195-196
      VBA code for, 196
Type intrinsic constants
      for CancelUpdate method, 203
      fo r Cr eateField method, 262-263
      for CreateProperty method, 97-98, 160, 266-267
      for CreateWorkspace method, 36
      for OpenRecordset method, 114, 164, 219, 268
      for setting return values, 158-159, 196
      for Update method, 224
      for Workspace object method, 57
Type property
      Field object, 311-312
      Parameter object, 325-326
      Property object, 347-348
      QueryDef object, 158-159
      Recordset object, 196-197
      VBA code for, 197, 312, 326
      Workspace object, 57
Type property intrinsic constants, 311, 325, 347-348

U[ Top ]
Undoing deletes, 207
Unique property, Index object, 339
Updatable property
      Database object, 93
      QueryDef object, 159
      Recordset object, 197-198
      TableDef object, 259-260
      VBA code for, 93, 197-198, 260
Update method
      Recordset object, 184, 202, 224-225
      Type intrinsic constants for, 224
      VBA code for, 225
UpdateOptions intrinsic constants, return value/settings, 198
UpdateOptions property, Recordset object, 198
Updating system files, 354
User object methods, 282, 288-291
      CreateGroup, 288-290
      NewPassword, 290-291
User object properties, 282, 286-288
      Name, 286
      Password, 286-288
      PID, 288
User objects
      access to, 283
      characteristics of, 281-282
      referencing, 279, 282, 284
UserName property
      Container object, 138-139
      VBA code for, 138-139
      Workspace object, 58
Users collection and User object, 281-291
Users collection methods, 282, 284-286
      Append, 284-285
      Delete, 285
      Refresh, 286
Users collection properties, 282-284
      Count, 283
      Item, 283-284
Users collections, DAO object model, 281

V[ Top ]
ValidateOnSet property, Field object, 313
ValidationRule property
      Field object, 313-314
      read/write characteristics of, 313
      Recordset object, 198-199
      TableDef object, 260-261
      VBA code for, 199, 261, 314
ValidationText property
      Field object, 314-315
      read/write characteristics of, 314-315
      Recordset object, 200
      TableDef object, 261
Value property
      Field object, 315
      Parameter object, 326
      Property object, 348-349
      VBA code for, 348-349
Variant data type, 2
VBA code
      for AbsolutePosition property, 178-179
      to access the DBEngine object, 22
      for AddNew method, 202-203
      advantages of, 14-15
      for AllPermissions property, 134
      for Append method, 53-54, 145-146, 232, 245, 275, 277, 284-285, 296-297, 331-332, 344
      for AppendChunk method, 312-313
      for Attributes property, 248, 300
      for BeginTrans method, 58-59
      for BOF property, 180-181
      for Bookmark property, 181-182
      for CancelUpdate method, 204
      for Clone method, 205
      for Close method, 95
      for CollatingOrder property, 83-84, 301-302
      for CommitTrans method, 58-59
      for CompactDatabase method, 33-35
      for ConflictTable property, 248-249
      for Connect property, 150, 250-251
      for the Container object, 127, 129
      for CopyQueryDef method, 206-207
      for Count property, 51-52, 81, 131-132, 231, 283, 295
      for CreateDatabase method, 62-63
      for CreateField method, 237-238
      for CreateGroup method, 65-66, 288-290
      for CreateIndex method, 264-265
      for CreateProperty method, 101, 161, 267
      for CreateQueryDef method, 103
      for CreateRelation method, 105-106
      for CreateTableDef method, 108
      for CreateUser method, 66-67, 279-280
      for DateCreated property, 150-151, 183, 251
      for DefaultCursorDriver property, 55
      for Delete method, 147, 207-208, 232-233, 246, 297-298, 332-333, 345
      for Description property, 45-46
      for DesignMasterID property, 86-87
      for DistinctCount property, 334
      for Edit method, 208
      for EditMode property, 184-185
      for EOF property, 185
      for Execute method, 110-111, 162-163
      for FillCache method, 209-210
      for Filter property, 186
      for FindFirst method, 211
      for FindLast method, 211-212
      for FindNext method, 212-213
      for FindPrevious method, 213-214
      for Foreign property, 335-336
      for ForeignName property, 304-305
      for ForeignTable property, 234
      for GetRows method, 215-216
      for Idle method, 36-37
      for Index object, 329-330
      for Inherit property, 135
      for Inherited property, 346-347
VBA code ([_Fi_]continued )
      for KeepLocal property, 151, 252
      for LastModified property, 187-188
      for LastUpdated property, 152, 188-189, 253
      for LoginTimeout property, 57
      for LogMessages property, 152
      for MakeReplica method, 112
      for Move method, 217
      for MoveLast method, 218
      for Name property, 88, 135-136, 153-154, 190, 253-254, 278, 286, 305-306, 336-337
      for NewPassword method, 113, 290-291
      for OpenConnection method, 71-72
      for OpenDatabase method, 73
      for OpenRecordset method, 221-222, 270
      for Owner property, 136
      for Parameter object, 320-321
      for PartialReplica property, 235-236
      for Password property, 287-288
      for PercentPosition property, 191-192
      permissions from, 65
      for Permissions property, 138
      for PopulatePartial method, 123
      for Primary property, 338
      for Properties property, 307, 324-325
      for the QueryDef object, 142-143
      for RecordCount property, 192, 254
      for RecordsAffected property, 89, 155
      for Refresh method, 133, 148
      for RegisterDatabase method, 38-39
      for Relation object, 227
      for RepairDatabase method, 39-40
      for Replicable property, 90-91, 156-157, 256-257
      for ReplicaFilter property, 258
      for ReplicaID property, 91-92
      for Requery method, 222-223
      for Restartable property, 193-194
      for Rollback method, 58-59
      for Seek method, 223-224
      for SetOption method, 40-41
      for Size property, 309
      for Sort property, 194-195
      for SourceField property, 310
      for SourceTableName property, 259
      for Synchronize method, 124-125
      syntactical differences from VBS code, 15-16, 96, 107-108, 128-129
      for TableDef object, 242-243
      for Transactions property, 196
      for Type property, 197, 312, 326
      for Updatable property, 93, 197-198, 260
      for Update method, 225
      for UserName property, 138-139
      using early binding, 4
      using late binding, 3-4
      using with Outlook 2000, 96
      for ValidationRule property, 199, 261, 314
      for Value property, 348-349
      for Version property, 30, 94-95
      versions of, 13
      (see also Access VBA code; Excel VBA code; Word VBA code)
VBA Err object, 42, 45
VBS code, 15
      for CollatingOrder property, 84
      syntactical differences from VBA code, 15-16, 96, 107-108, 128-129
      versions of, 13
      (see also Outlook VBS code)
VBScript, 2, 4
Version property
      Database object, 94-95
      DBEngine object, 29-30
      VBA code for, 30, 94-95
Versions
      application, 29-30
      Jet Engine, 29-30
      VBA, 13
      VBS, 13
VisibleValue property, Field object, 315
Visual Basic for Applications (VBA), 2-7
Visual Basic programmers, tools for, 351
Visual Basic (VB) dialects, 1-2, 11-16
      listed, 13-14
      (see also VBA code; VBS code)
V1xNullBehavior property, Database object, 93-94

W[ Top ]
Windows 3.0 clipboard, 1
Windows 98 Registry Editor, Excel ISAM formats in, 29
Windows Office 2000, 2
Word custom database properties, Access vs., 98
Word Range object, 1
Word table, data imported into, 21, 166
Word VBA code
      to access the DBEngine object, 22
      for IniPath property, 28
      for OpenRecordset method, 120-121, 166-168
Workgroup
      confirmation message on joining, 277
      file name of, 276
      selecting, 276
Workgroup Administrator, 29, 275-276
Worksheet_Open event, 117
Workspace collections, 50
Workspace object methods, 30, 37, 40, 50, 58-76
      BeginTrans, 58-59
      Close, 60
      CommitTrans, 60
      CreateDatabase, 60-64
      CreateGroup, 64-66
      CreateUser, 66-67
      OpenConnection, 68-72
      OpenDatabase, 72-76
      Rollback, 76
      Type intrinsic constants for, 57
Workspace object properties, 50, 54-58
      DefaultCursorDriver, 54-55, 203
      IsolateODBCTrans, 55-56
      LoginTimeout, 56
      Name, 56-57
      Type, 57
      UserName, 58
Workspace objects
      naming rules, 56
      referencing, 49
      removing, 60
      retrieving, 52
Workspaces collection and Workspace object, 48-76
      in the DAO object model, 48
Workspaces collection methods, 30, 49, 53-54
      Append, 53-54
      Delete, 54
      Refresh, 54
Workspaces collection properties, 49, 51-53
      Count, 51-52
      Item, 52-53

X[ Top ]
XREF, 263, 328

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)