Index

and Access 2003, 294–298

assigning passwords, 290

assigning permissions, 291

changing users programmatically, 291–294

compiling to an .mde file, 287–288

creating an administrator, 289–290

creating passwords programmatically, 285–286

digital certificates, 296–298

digital signatures, 295–298

Jet Sandbox, 294–295

Macro Security, 295–298

password-protecting the VBA code, 287

setting passwords, 284–285

turning off the Access user interface, 284

user-level, 288–294

CommandBar object, 304–307

FileSearch object, 302–304

customizing, 55–56

See also menus

definition and analysis of requirements, 14–16

development of the design, 17–23

documentation, 24–25

evaluation of requirements, 16–17

implementation and testing, 23–24

maintenance, 25

steps, 14

concatenation, 161

INNER JOIN keyword, 156–157

ORDER BY keyword, 156

output, 161–163

Query grid, 154

SELECT keyword, 154–155

SQL View, 153, 154

and VBA, 157–160

WHERE keyword, 155

features, 334

Microsoft Access vs., 334

migrating Access to, 17

Service Manager, 336

stored procedures, 342–344

See also Access Data Projects

See also dynamic arrays

declaring, 166

vs. functions, 201–202

See also procedures

See also menus