Real World Microsoft Access Database Protection and Security

M

macros, protecting, 382

Main Switchboard form command, 207

MAKEMDE constant, 398

McNally, Mark, 173

MDB database, 390, 391, 393, 399

MDB format, 289, 390, 393, 394

MDE format, 391 “99

creating MDE database automatically, 395 “99

and database passwords, 394

encrypting MDE databases, 399

hiding location of front-end database, 437

hiding queries in MDE databases, 394

overview, 8, 15

problems with, 393

using forms in MDE databases, 394 “95

when MDE database is applicable , 392 “93

and workgroup security, 394

.MDW files, 244, 245

Me column (on Access Workbench), 174

menus , 197 “232

allowing changes, 29 “30

building, 199 “210

custom menu, 204 “8

custom toolbar menu, 201 “4

overview, 199 “200

shortcut menu, 208 “10

built-in, modifying, 224 “29

custom development of, options requiring, 28 “29

integrating menus into forms and reports , 212 “24

adding custom toolbars and shortcut menus to all forms, 213 “18

menu and toolbar startup options, 218 “24

overview, 212 “13

overview, 197 “99

Microsoft Excel application, 373

Microsoft Word, 292, 300

Modify Design permission, 394

Modify permission, 430

module permissions, 370

MS Access Workgroup Administrator.lnk file, 245

MSGMINS constant, 118

MSysACEs table, 349

MSysCompactError system table, 58, 59

multi- user databases, backing up and recovering, 112 “20

checking whether anyone has database open , 113 “18

overview, 112 “13

setting automatic shutdowns before scheduled backups , 118 “20