S

sandbox mode, 778

limitations, 779-780 workarounds, 780 SCC. See source code control Schema enumeration, Connection object,

893-900 Schema objects ADOX creation, 223-230 indexes, 228-230 relationships, 230 tables and columns, 226-228 views, 224-225

DAO creation, 132-143 indexes, 136-138 MVF, 140-143 relations, 138-140 tables and fields, 133-136 schema recordsets, 219-221 Screen object, 953 Section object, 953-956 events, 955-956, 961-962 properties, 954-955 security, 58, 60-62, 595, 755-756 ACCDB file format, 55, 60-61, 595-606 overview, 595-597 shared-level, 597-602 VBA, 602-606 ACCDB/MDB v. ADP 670-671 ACCDE file format, 603-604 Access and SharePoint, 58 ADO, 231 DAO, 147-157

digital certification, 769-776 self, 772-776 types of, 770-772 digital signature, 769, 776-778 creating, 776-777 extracting, 777-778 Disabled mode

AutomationSecurity, 765-767 database enabling, 763-764 macros, 767-769 modal prompts, 765 overview, 62, 761-762 reasons, 762-763 encryption with database password, 60-61 Expression Service, 778-780 limitations, 779-780 sandbox mode, 778 workarounds, 780 libraries, 810 MDB file format, 606-647 encoding, 612-614

overview, 606-610 shared-level, 611-612 user-level, 616-647 VBA code, 614-616 Message Bar, 62, 761 Outlook, 540-542 Exchange Server, 541 Redemption, 541-542 signed database package, 61 Trust Center, 61-62, 756-761 features, 757-761 overview, 756 trusted locations, 61-62, 757-759 Security IDentifier (SID), new account,

147-148 Security Warning message bar, 62 Seek method, Recordset, 175-176, 210-211 Select Case, 249 SELECT query, multiple, 217-218 Selection object, methods, 22 SelectRecords procedure, expandable, 519 SendObject method, DoCmd, 323 separator, for Ribbon customization, 388 Server-side cursors, 195 SetOption method Application object, 962-969 advanced, 967-968 current database, 963-964 datasheet, 964-965 object designers, 965-966 popular, 963 proofing, 966-967 database encryption, 146 SetPermissions method, Groups and Users, 900-903

Settings tab, for Ribbon customization, 415-417

SetWarnings method, DoCmd, 280, 285, 313

Shape statement, Recordset object, 206-208

shared-level security

ACCDB file format, 597-602 data encryption, 597-598 encrypt and password protect, 598-602 MDB file format, 611-612 Access user interface, 612 back-end databases, 611-612 VBA code, 612 SharePoint. See Windows SharePoint Server SID. See Security IDentifier signed integers, C and API, 498 SingleStep action, 27 SmartTag object, 956 Snapshot Viewer deprecation, 66 Sort property, 167, 209 source code control (SCC) installation, 747-748 support for, 65, 747-753 using, 748-752 add database, 749 creating database, 749 modifying database, 749 options, 750-752 special characters ASCII, 1025-1026 code example, 1026 list, 1024 overview, 1023 splash screen, 1071-1072 split application, 1064 SQL. See Structured Query Language SQL Server 2005, Microsoft Access 2007,35-36, 60 upgrading to, 793-794 client-server application, 650-651 external data link, 665-668 overview, 3

query options, 668-669 functions, 669 procedures, 669 views, 668-669 SQL Server Profile, Access, 660 stacked layout, forms, 296-297

State property, 223

Static variables, 101

Stream object, ADO, 200-201, 887-888

string comparisons, 90-92 data type, 89-90 C and API, 501-503 string concatenation, 273-274

& v. +, 273-274 example, 274 SQL strings with, 512-513 Structured Query Language (SQL)

enhance forms, 514-530

cascading combo boxes, 522-524 inside queries, 529-530 report selection criteria, 524-529 selections on index forms, 516-522 sorting on columns, 514-515 open forms and reports, 513-514 ReplaceOrderByClause function, 530-536 ReplaceWhereClause function, 530-536 statement build with quotes, 510-511 concatenating long, 512-513 recordset based on, 164 single quotes v. double quotes, 511-512 in VBA, 509-513 VBA and, 509-536 sub of classes, 430-432 function v., 238-239 subforms, 956-960

events, 960-961 methods, 959

properties, 37, 47, 957-959

new, 37, 47 refer to, 258-259 subreports, 960

refer to, 258-259 suffixes, in class naming, 442 Summarylnfo properties, setting and retrieving, 130-131

sums, rounding, 271

SysCmd 603, ACCDE file format, 604

Was this article helpful?

0 0

Post a comment