Index_A

A

accelerator keys, homemade, 45 “47

Access 2000, new security features, 18

Access 2002

new security features, 17 “18

recovering data from XML files, 137 “38

using XML methods to export tables, 134 “37

Access accounts, logging, 176 “82

completing user log, 180 “82

initiating user log, 178 “80

overview, 176 “78

Access Data Projects (ADPs), 390 “91

Access Editors group , 405, 407, 418, 437

assigning network account to, 425 “27

bundling related databases in same folder used by, 438

denying ability to list contents of folder, 429 “33

denying ability to list files in folder, 428 “29

setting permissions for folder to be used by, 420 “24

setting up new, 416 “17

testing permissions, 424 “25, 434 “36

Access Editors Properties dialog, 417

Access Login column (on Access Workbench), 175

Access protected folder strategy, 427 “39

denying users ability to list folder contents, 429 “33

other permission-related topics, 438 “39

overview, 427 “28

setting up new DBA group, 428 “29

and shortcut files, 436 “37

testing permissions, 434 “36

Access security newsgroup, 241

Access Special Keys option, 30

Access Unlimited newsletter, 21

Access Workbench program, 148, 173 “76

ActiveX Data Objects. See ADOs (ActiveX Data Objects)

Add New User dialog, 425

Add User xxx To Group command, 257

admin account, 253

Administer permissions, 253, 368, 369, 370, 394

Administrator account, 420

Administrators group, 422, 424

Admins administration group, 256

Admins group, 251, 252, 253, 256, 259, 260, 367, 370, 371

ADO connection, 166, 168, 175

ADO database passwords, 304

ADO Extensions (ADOX) library, 259, 399

ADO library, 18, 164, 166

ADO RecordSet property, 377

ADOs (ActiveX Data Objects), 116, 135, 138, 139, 164

ADP, 390, 391, 400

adPersistADTG constant, 139

adPersistXML constant, 139

ADPs (Access Data Projects), 390 “91

advapi32.dll file, 188

Allow Access Special Keys option, 102

Allow ByPass Key option, 290

AllowByPass option, 86, 390

AllowByPassKey property, 25, 42 “45, 47, 220, 224

AllowToolbarChanges option, 29

ALREADYOPEN constant, 116

Alter User xxx Password command, 257

Anonymous Admin account, 310 “11, 367, 371

anonymous Admin user

explanation of term , 309 “10

varying permissions for on individual tables, 313 “15

Anonymous Windows Authentication (AWinA), 308, 346 “49, 350 “55

Anonymous Windows Authentication Pro, 353 “54

anti-spyware software, 446

antivirus software, 446

API (application programming interface), 187

Append to Existing Data option, 137

Application object, 126, 134, 142, 145

application programming interface (API), 187

Apress Web site, 20

attributes. See database options and attributes

Attributes property, 75

author's email address, 21

Auto Compact Percentage property, 59

AutoExec macro, 83 “87, 162, 277

adding forms to database with, 118

alternative to, 330

creating, 84 “86

use of, 86 “87

autoexec.bat file, 83 “84

Autokeys macro, 46

Automation command, 302

AWinA. See Anonymous Windows Authentication (AWinA)

AWinA Group account, 354