Microsoft Access 2010 Bible

xxx

Contents

Examining Access Web Application Limits .....................................................................1141

Not public-facing ..................................................................................................1141

Fewer than 20,000 rows of data ............................................................................1143

Modest transactional requirements ........................................................................1143

Summary ........................................................................................................................1144

Chapter 35: Deploying Access Applications to SharePoint . . . . . . . . . . 1145

Looking at SharePoint Deployment Options ...................................................................1146

Enhanced table exporting option ...........................................................................1146

Publishing to SharePoint option ............................................................................1156

Dealing with Compatibility Checker Problems ................................................................1174

General errors .......................................................................................................1174

Relationship and lookup errors .............................................................................1174

Form and report errors ..........................................................................................1175

Query errors ..........................................................................................................1176

Macro errors ..........................................................................................................1177

Schema errors .......................................................................................................1178

Summary ........................................................................................................................1179

Part VI: Access as an Enterprise Platform 1181

Chapter 36: Client/Server Concepts . . . . . . . . . . . . . . . . . . . . . . . . . . . 1183

Looking at the Parts of Client/Server Architecture ...........................................................1184

Applications ..........................................................................................................1186

The back office ......................................................................................................1187

Making Sense of Multi-Tier Architecture .........................................................................1192

Two-tier systems ...................................................................................................1193

Three-tier systems .................................................................................................1193

Putting It All Together: Access, Client-Server, and Multiple Tiers ...................................1194

Access as a database repository ..............................................................................1195

Access as an Internet database ...............................................................................1197

Summary ........................................................................................................................1197

Chapter 37: SQL Server as an Access Companion  . . . . . . . . . . . . . . . . 1199

Connecting to SQL Server ...............................................................................................1201

Introducing connection strings ..............................................................................1201

Connecting to SQL Server from Access .................................................................1203

Working with SQL Server Objects ..................................................................................1214

Using SQL Server tables from Access .....................................................................1215

Views ....................................................................................................................1217

Stored procedures .................................................................................................1219

Triggers .................................................................................................................1221

Summary ........................................................................................................................1221

02_475348-ftoc.indd xxx02_475348-ftoc.indd xxx 4/1/10 1:42 PM4/1/10 1:42 PM