Real World Microsoft Access Database Protection and Security

B

backing up and recovering databases, 109 “59

compacting databases, 124 “28

creating compressed (.ZIP) archives, 122 “24

exporting and recovering programming objects, 140 “52

exporting all programmable objects to text files, 142 “45

exporting of objects to text, how works, 147 “52

exporting VBA module to text file, 140 “41

importing all programmable objects into blank database, 145 “47

importing VBA text file back into database, 141

overview, 140

saving and retrieving objects by using hidden methods , 141 “42

further reading, 158 “59

how the text backup files help, 152 “56

multi- user databases, 112 “20

checking whether anyone has database open , 113 “18

overview, 112 “13

setting automatic shutdowns before scheduled backups , 118 “20

normal backups, 120 “22

overview, 9, 109 “11, 447

saving tables to text files, 128 “39

overview, 128 “29

recovering data from Access 2002 XML files, 137 “38

recovering data from comma-delimited text files, 132 “34

saving tables to comma-delimited text files, 129 “32

using Access 2002 XML methods to export tables, 134 “37

using ADO to generate XML files in Access 2000, 139

by using Access 2003, 156 “58

Backup menu command, 157

BAS files, 149, 151

basGR10_Files module, 93

basGR8_RefreshTableLinks module, 93

basGR8_Startup module, 93, 184, 188

basOpenProtected module, 378, 380, 381

Begin a Group command, 204

building security, 447

Built-in Form View toolbar, 201

built-in menus , 224 “29

built-in toolbars , 222

bundling related databases in folder, 438

Bypass key, 31, 44 “45