1330
Index
permissions, 1121
SharePoint templates, 1131–1134
SharePoint, Web application limits
anonymous site access, 1141
maximum data rows, 1143
public-facing sites, 1141–1143
transactional requirements, 1143
SharePoint deployment. See also distributing applications.
.accdb file, copying, 1145
.accdb file, eliminating, 1156–1173
Access forms, creating, 1169–1170
Access ribbon, Web commands, 1168
Access Services, 1157
export errors, 1151
Navigation form, 1170–1171
publishing Access applications, 1156–1157, 1164–1173
relationship issues, 1160–1164
synchronizing desktop application with Access Services,
1171–1173
tables, enhanced export options, 1146–1156
SharePoint deployment, Compatibility Checker
Backstage area, 1158
data integrity, enforcing, 1162–1163
online help, 1160
running, 1157–1158
successful completion, 1163–1164
SharePoint deployment, Compatibility Checker problems
attachment field limitations, 1178
AutoNumber data type problems, 1179
calculated field issues, 1178
control issues, 1176
field data type issues, 1178
form errors, 1175–1176
form event problems, 1175
general errors, 1174
incompatible custom field formats, 1179
incompatible fields, 1174
incompatible macro actions, 1177–1178
invalid expression errors, 1177
invalid query names, 1177
issues, displaying, 1158–1159
lookup errors, 1174–1175
lookup field issues, 1175, 1178
macro errors, 1177–1178
object name violations, 1176
primary key constraints, 1175
query errors, 1176–1177
query join issues, 1177
relationship errors, 1174–1175selecting
controls, 271–272
fields, 475, 476–477, 484
records in forms, 231
selecting data. See queries; SQL (Structured Query
Language).
selecting from lists. See combo boxes; list boxes.
Selection Behavior option, 357
Selection command, 243–244
selection criteria, specifying, 134. See also queries; SQL
(Structured Query Language).
SelectionChange event, 464
self-joins, 167–169
semicolon (;)
input mask separator, 67
SQL end-of-statement indicator, 484
SendEmail action, 561
separators on the ribbon, 1038–1039
servers. See client/server architecture.
SetField action, 561
SetLocalVar action, 561
SetOption method, 926–927
SetProperty function, 683–685
SetTempVar action, 1065–1068
SetWarnings action, 1054–1055, 1056
SetWindowTextA function, 961–962
SharePoint
Access Services, 1140–1141
alerts, 1138
Backstage area, 1139–1140
end-user maintenance, 1138
managed applications, 1136
migrating Access applications to the Web, 1135,
1138–1140
new features, 1265
overview, 1104–1106
Publish to Access Service button, enabling,
1139–1140
recycle bin, 1138
security, 1138
versioning, 1138
Web publishing, 1137–1140
SharePoint, as a data source
calendars, linking to, 1122–1123
data type conversion, 1127
exporting Access tables to SharePoint, 1123–1127
linking Access to SharePoint lists, 1119–1123
moving Access tables to SharePoint, 1127–1131
overview, 1117–111952_475348-bindex.indd 133052_475348-bindex.indd 1330 4/1/10 2:02 PM4/1/10 2:02 PM