Cover image for Access 2002 : enterprise developer's handbook
Access 2002 : enterprise developer's handbook
Litwin, Paul.
Personal Author:
Publication Information:
San Francisco, Calif. ; London : SYBEX, [2002]

Physical Description:
xxxviii, 952 pages : illustrations ; 23 cm + 1 computer optical disc (4 3/4 in.)
Microsoft Access is a home and small office database, and is used as a front end to Microsoft's SQL Server database. This text covers forms, reports, database design, building add-ins, and working with the Windows API.
General Note:
Includes index.
Title Subject:
Subject Term:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 L592 2002 Book and Software Set Central Closed Stacks

On Order




The latest from internationally recognized Access authorities Litwin, Getz, and Gunderloy, Access 2002 Enterprise Developer's Handbook offers complete coverage of every aspect of building client-server Access applications for large-scale enterprises. Inside, you'll find scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges.

Coverage Includes:
* Developing Access projects that store data using SQL Server
* Managing concurrency using stored procedures
* Creating data access pages that allow the editing and viewing of Access and SQL Server data in a browser
* Using data access pages to validate data, link pages, and create dynamic HTML effects
* Retrieving and editing server data directly with ADO
* Managing multiple developers with source code control
* Creating Web pages that connect to Access and SQL Server data
* Controlling all aspects of replication
* Securing your Access databases and projects
* Distributing your Access applications
* Importing and exporting XML files
* Creating and managing SQL Server objects

Author Notes

Paul Litwin is the owner of Litwin Consulting and a founding partner of Deep Training, where he focuses on training, mentoring, and writing about Access, ASP.NET, and Visual Studio .NET. He is the editor-in-chief of aspnetPRO , a magazine for ASP.NET developers.

Ken Getz is a senior consultant with MCW Technologies, where he focuses on development, training, and writing about Microsoft technologies, including Visual Studio .NET and Microsoft Office. He speaks regularly at industry conferences.

Mike Gunderloy , an independent consultant and developer in eastern Washington, is coauthor of Mastering SQL Server 2000 and SQL Server Developer's Guide to OLAP with Analysis Services , and author of Visual Basic Developer's Guide to ADO , all from Sybex. Paul, Ken, and Mike together wrote this book's companion volume, Access 2002 Desktop Developer's Handbook .

Table of Contents

Introductionp. xxix
Chapter 1 What's New in Access 2002p. 1
A Brief Access Historyp. 2
Access 2002p. 5
Microsoft Office XP Developer Featuresp. 8
Summaryp. 9
Chapter 2 Developing Multiuser Jet Applicationsp. 11
File-Server versus Client-Serverp. 12
Splitting Databasesp. 12
Multiuser Settingsp. 22
Locking and Formsp. 27
Locking and Recordsetsp. 42
Transaction Processingp. 55
Using a Custom AutoNumber Routinep. 64
User Lists and Connection Controlp. 68
Other Considerationsp. 71
Summaryp. 72
Chapter 3 Designing Client-Server Applicationsp. 75
Comparing Client-Server and File-Server Systemsp. 76
Understanding OLE DBp. 85
Understanding ODBCp. 90
Query Parsingp. 92
Managing ODBC Record Sourcesp. 93
Configuring ODBCp. 94
Getting at Server Datap. 97
Evaluating Query Alternativesp. 107
Configuring ODBC for Your Systemp. 107
Configuring Your Server for Accessp. 109
Editing ODBC Datap. 110
Understanding Your Serverp. 112
Designing an Efficient Client-Server Applicationp. 113
Building Your Formsp. 117
Building Reportsp. 119
Common Client-Server Migration Problemsp. 121
Looking in on Jet and ODBCp. 122
Summaryp. 125
Chapter 4 Creating SQL Server Databasesp. 127
SQL Server Versionsp. 128
Creating Access Projectsp. 133
Creating Tables and Indexesp. 147
Understanding Table Limitationsp. 155
Creating Viewsp. 156
Creating Database Diagramsp. 169
Other SQL Server Objectsp. 171
Managing SQL Server Databases from Accessp. 173
Summaryp. 174
Chapter 5 Creating Stored Procedures, Functions, and Triggersp. 175
The Stored Procedure Advantagep. 176
Working with Access Project Queriesp. 176
Stored Procedure Syntaxp. 178
Understanding Parameters and Variablesp. 180
Executing Stored Proceduresp. 183
Using Transact-SQL Control-of-Flow Statementsp. 188
Using Built-In Variables, Functions, and Proceduresp. 196
Grouping Operations with Transactionsp. 200
Creating Functionsp. 203
Creating Triggersp. 207
Summaryp. 212
Chapter 6 Using ActiveX Data Objects with Server Datap. 213
ADO Object Modelp. 214
Creating Connectionsp. 214
Using Command Objectsp. 221
Creating Server Recordsetsp. 239
Managing Concurrencyp. 246
Handling ADO Eventsp. 261
Dealing with Errorsp. 265
Summaryp. 269
Chapter 7 Developing ADP Applicationsp. 271
Using Forms in Access Projectsp. 272
New and Changed Form Propertiesp. 274
What's Missing?p. 280
Data Updateabilityp. 280
Using Transactions with Bound Formsp. 281
Optimizing Formsp. 283
Using Reports in Access Projectsp. 284
Using Extended Propertiesp. 298
Record Lockingp. 304
Summaryp. 310
Chapter 8 Securing Your Applicationp. 311
Jet Security Basicsp. 312
Jet Workgroup-Based Securityp. 314
Jet Workgroupsp. 315
Jet User and Group Accountsp. 317
Assigning Jet Permissionsp. 321
Permissions for New Objectsp. 324
Explicit versus Implicit Permissionsp. 324
Security for Modulesp. 325
Who Can Change Permissionsp. 326
What Happens to Permissions for Deleted Accounts?p. 327
Jet Object Ownershipp. 327
Jet Database Encryptionp. 329
Programming Jet Securityp. 330
DAO Security Overviewp. 331
ADOX Security Overviewp. 352
Managing Jet Security with SQLp. 370
Choosing DAO, ADOX, or SQLp. 376
Securing a Jet Database with the Access 2002 Security Wizardp. 377
Unsecuring a Secured Jet Databasep. 381
Migrating Secured Jet Databases to Access 2002p. 381
Jet Security and Linked Tablesp. 382
Access Data Project (ADP) Securityp. 382
Summaryp. 394
Chapter 9 Mastering Replicationp. 397
Jet Replication: What Is It and How Does It Work?p. 398
When to Use Replicationp. 400
The Many Faces of Replicationp. 403
Replication Topologiesp. 410
Changes Jet Makes to a Database When It Is Replicatedp. 414
Replicating a Databasep. 419
Partial Replicationp. 432
Preventing Replicationp. 439
Reversing Replicationp. 439
Synchronizing Replicasp. 440
Managing Conflictsp. 453
Other Replication Issuesp. 464
Summaryp. 469
Chapter 10 Creating Data Access Pagesp. 471
What Are Data Access Pages?p. 472
What Can You Do with Data Access Pages?p. 474
Creating Data Access Pagesp. 476
Managing Data with Data Access Pagesp. 479
Managing Data Access Pagesp. 531
Deploying Data Access Pagesp. 533
Summaryp. 553
Chapter 11 Scripting Data Access Pagesp. 555
Good News/Bad Newsp. 556
Microsoft Script Editor Orientationp. 556
Client versus Server Scriptingp. 567
VBScript versus VBAp. 567
Using Option Explicitp. 568
Working with Data Access Page Objectsp. 568
Validating Datap. 577
Employing Dynamic Styles and Event Bubblingp. 580
Filtering Datap. 583
Adding Items to a Listp. 585
Summaryp. 587
Chapter 12 Using the Office Web Componentsp. 589
What Do You Getp. 590
The Office Spreadsheet Componentp. 599
The Office PivotTable Componentp. 613
Persisting PivotTable Settingsp. 629
The Office Chart Componentp. 634
Summaryp. 650
Chapter 13 Using Access as a Web Clientp. 651
What Are Hyperlinks?p. 652
Creating an Access Hyperlink--the Hard Wayp. 653
Creating an Access Hyperlink--the Easy Wayp. 654
Where to Find the Linksp. 655
Using Hyperlinks for Intra-database Navigationp. 660
Controlling Hyperlinks with VBAp. 662
The Hyperlink Object Propertiesp. 662
The AddToFavorites Methodp. 663
The Follow and FollowHyperlink Methodsp. 663
The CreateNewDocument Methodp. 667
The HyperlinkPart Methodp. 667
Using the Microsoft Web Browser Controlp. 669
Summaryp. 673
Chapter 14 Publishing Access Data on the Webp. 675
Publishing Access Data Using the Export Dialog Boxp. 676
Hand-Coding Active Server Pagesp. 691
The Anatomy of an ASP Pagep. 694
ASP Scriptsp. 694
What the Browser Seesp. 695
Sending Information Back to the Browserp. 696
VBScriptp. 697
The ASP Object Modelp. 699
Using Include Filesp. 711
Creating Data-Driven ASP Pagesp. 712
Using the Office Web Components from ASP Pagesp. 739
Summaryp. 752
Chapter 15 Integrating Access with XMLp. 753
Understanding XMLp. 754
Importing and Exporting XML Datap. 771
XML Presentation Outputp. 782
Summaryp. 788
Chapter 16 Using Source Code Controlp. 789
What Is Source Code Control?p. 790
Support for Source Code Control in Access 2002p. 792
Using Microsoft Visual SourceSafep. 800
Working with VSS from Access 2002p. 804
Controlling SourceSafe with VBAp. 815
Summaryp. 824
Chapter 17 Setup and Deploymentp. 825
Understanding the Access Runtimep. 826
Understanding the Windows Installerp. 828
The Windows Installer Automation Interfacep. 840
The Packaging Wizardp. 846
Customizing Setupp. 853
Editing Installer Filesp. 854
Deploying Data Access Pagesp. 875
Summaryp. 876
Appendix A The Reddick VBA Naming Conventions, Version 7p. 879
An Introduction to Hungarianp. 880
Summaryp. 899
Appendix A VBA versus VBScriptp. 901
Indexp. 904