Index

References to figures and illustrations are in italics.

A

Access

centralization vs. decentralization, 362–363

connecting with, 151–153

connecting with Excel, 308–310

connecting with Outlook, 310–312

connecting with Word, 312–313

developing in, 5–10

future of, 10–11

history of, 4

interacting with, 47–55

migrating to SQL Server, 17

and security, 283–288

security and Access 2003, 294–298

vs. SQL Server, 334

Access Data Projects, 335–336

stored procedures, 342–344

Upsizing Wizard, 337–342

upsizing your Access database, 336–342

views, 345–346

working with an ADP file, 342–346

See also SQL Server

Access objects, 70–71

See also objects

Active Data Objects. See ADO objects

ActiveX Data Objects. See ADO

AddMenu, 386

AddRemoveButton procedure, 261

administrator, creating, 289–290

ADO, 367

ADO Data Control

adding to Visual Basic, 374–381

properties, 376

properties and values for the controls, 379–380

ADO Errors collection, 189–192

ADO objects, 68–70

equivalents to Access data types, 179

See also objects

ADOB library, 291

ADODB library, 176

ADOX library, 176, 291

Catalog object, 177

Column object, 177

constructing a table, 177–180

Index object, 177

Key object, 177

Table object, 177

ADP. See Access Data Projects

algorithms, 16

ALTER DATABASE PASSWORD, 285–286

AND operator, 95–97

AnswerWizard object, 302

Application object, 67

ApplyFilter, 386–387

arrays, 104

components, 104–110

dynamic arrays, 105

erasing, 110

making arrays smaller, 110

runtime errors, 109–110

static arrays, 105–107

Assert member, 196, 197

assignment statements, 90

Assistant object, 302

attributes, 19, 67, 124, 140

Auto Data Tips, 131–132

Auto Indent/Tab Width, 132

Auto List Members, 129–130

Auto Quick Info, 130–131

Auto Syntax Check, 128–129

AutoForm, 217, 218, 219