Access 2000 Client/Server Solutions Book

	Introduction	xix
Part I	Client/Server Development With DAO And ADO
Chapter 1	Working With DAO	3
	Introduction To Data Access Objects	3
	The DAO Object Model	4
	The Containers Collection	12
	Understanding And Using The DBEngine Object	14
	Using The CurrentDB Function	14
	Creating And Modifying Database Objects Using Code	15
	Creating A Query Using Code	17
	Understanding Recordset Types	18
	Working With Recordset Properties And Methods	19
	Modifying Table Data Using Code	27
	Sorting, Filtering, And Finding Records	30
	Running Parameter Queries	33
	Where To Go From Here	34
Chapter 2	A Brief Introduction To Client/Server With Access	35
	Designing Your Application With Multiuser Issues In Mind	35
	Understanding Access's Locking Mechanisms	38
	Locking And Refreshing Strategies	39
	Form Locking Strategies	42
	Recordset Locking	43
	Effectively Handling Locking Conflicts	52
	Testing A Record For Locking Status	53
	Using Code To Refresh Or Requery	55
	Creating Custom Counters	56
	Moving On To Specific Client/Server Techniques	56
	Client/Server Strategies	61
	Briefly Considering The Use Of DAO With ODBCDirect	66
	Where To Go From Here	68
Chapter 3	Building Client/Server Applications By Exporting And Linking Tables	69
	Roles That Access Can Play In The Application Design Model	69
	The Basics Of Linking To External Data	72
	When And Why To Use Importing, Linking, And Opening	74
	Importing External Data	77
	Creating A Link To External Data	81
	Refreshing And Removing Links	88
	Opening An External Table	90
	Understanding Windows Registry Settings	92
	Special Considerations	92
	Troubleshooting With External Data	94
	Links And Performance Considerations	94
	Working With The Database Server	95
	Using Replication To Improve Performance	102
	Upsizing: What To Worry About	102
	Where To Go From Here	105
Chapter 4	Introduction To ActiveX Data Objects And OLE DB	107
	Analyzing OLE DB	108
	Understanding OLE DB Error Objects	114
	Using OLE DB From Within Applications	115
	Understanding The ActiveX Data Object (ADO) Object Model	116
	Working With ADO Recordset Properties And Methods	122
	Considering The ADO Event Model And Asynchronous Operations	127
	Where To Go From Here	129
Chapter 5	Converting From DAO To ADO	131
	Using ADO Instead Of DAO	131
	Sorting, Filtering, And Finding Records	140
	Running Parameter Queries	142
	Where To Go From Here	143
Chapter 6	Advanced ADO Issues	145
	Understanding Cursors	145
	Choosing Cursor Types	151
	Enforcing Data Integrity	152
	Working With Disconnected Recordsets	164
	Brief Discussion Of ADO Good Programming Principles	167
	Creating Objects With Class Modules	169
	Creating Classes	173
	More On Private And Public Procedures And Functions	184
	Creating The Time-Based Class Module	186
	Where To Go From Here	190
Part II	Access MDB As Front End
Chapter 7	Using Access 2000 As A Front End To SQL Server	193
	The SQL Server Engine	193
	The Relational Engine And The Storage Engine	200
	Managing Memory	214
	The SQL Server Kernel And Its Interaction With The Operating System	221
	Where To Go From Here	230
Chapter 8	Using Oracle And Access For Client/Server	231
	Global View Of The Oracle Architecture	232
	Considering Oracle's File Types	237
	System And User Processes	239
	Understanding How Oracle Uses Memory	245
	Understanding Oracle Data Storage	248
	Understanding Some Of The System Database Objects	251
	Oracle Data Management Considerations	253
	Distributed Databases	257
	Following A SQL Statement Through The Architecture	258
	Creating A Data Source Name (DSN)	260
	Where To Go From Here	268
Part III	Access Data Project As Front End
Chapter 9	Introduction To Access Data Projects	271
	Considering ADPs And SQL Server Objects	271
	Working With Basic ADPs	277
	Creating Data Types	287
	Creating And Dropping User-Defined Data Types	288
	Where To Go From Here	291
Chapter 10	Creating Databases, Tables, And Views With SQL Server	293
	Creating And Dropping Databases	293
	Creating Tables	297
	Types Of Data Integrity	308
	Using Constraints	310
	Introduction To Views	317
	Creating, Altering, And Dropping Views	319
	Where To Go From Here	329
Chapter 11	Understanding, Managing, And Working With Stored Procedures And Triggers	331
	Introduction To Stored Procedures	331
	Creating, Executing, And Modifying Stored Procedures	335
	Using Parameters And Error Messages With Stored Procedures	344
	Introducing Triggers	350
	How Triggers Work	358
	Where To Go From Here	368
Chapter 12	Additional Programming And ADP Issues With Client/Server Development	371
	Understanding Transaction Processing	371
	Managing Stored Procedures And Using Flow-Control Statements	387
	Using Flow-Control Statements	392
	Using Additional Procedure And Batch Keywords	399
	Using Triggers	405
	Using Access Data Projects To Manage SQL Server Objects	410
	Where To Go From Here	414
Chapter 13	Access Data Projects And Security	415
	SQL Server Security Modes	415
	Logins, Roles, And Groups	420
	SQL Server Object Permissions	431
	Planning Security	439
	Security Best Practices	441
	Where To Go From Here	443
Chapter 14	Advanced Programming With Access Data Projects	445
	Reporting And Forms With ADPs	445
	Programmatic Issues	451
	Where To Go From Here	460
Part IV	The Internet With Access 2000
Chapter 15	Introduction To Data Access Pages	463
	Understanding Data Access Pages (DAPs)	463
	Understanding And Using DAP Properties	478
	Optimizing Data Access Page Performance	491
	Where To Go From Here	493
Chapter 16	Web Programming With Access 2000	495
	Traditional Approaches	495
	Using Hyperlinks	501
	Revisiting Data Access Pages	504
	Where To Go From Here	515
Part V	The Internet With Other Microsoft Technologies
Chapter 17	Microsoft Web-Based Design Techniques	519
	Evolution Of The Web	520
	Considering The Web-Based Solution Models	526
	Introducing Visual InterDev	539
	Creating HTML Pages With InterDev	548
	Where To Go From Here	559
Chapter 18	Using Active Server Pages For Client/Server	561
	Defining Active Server Pages	561
	Understanding How HTTP And ASP Work Together	563
	Coding Active Server Pages	565
	Further Considering HTTP Communication	570
	Understanding The Importance Of State	579
	Considering Events	582
	Understanding Cookies	583
	Using COM Components	584
	Using Page Objects	588
	Security Issues With Active Server Pages	591
	Data Access From Active Server Pages	597
	Connecting The ASP To The Database	604
	Scripting Object Model	607
	Where To Go From Here	610
Chapter 19	Creating Middle-Tier COM Components With Visual Basic 6	611
	More Closely Evaluating The Business Layer	611
	Creating COM Components In Visual Basic	614
	Testing COM Components	620
	Using The Business Component In The Web Site	622
	Working With COM Components Inside Web Applications	625
	A Little More On How COM Components Work	628
	Where To Go From Here	630
Chapter 20	Using The Dynamic Client	631
	Understanding Dynamic HTML	631
	Error Handling In Web Applications	638
	Working With Objects	640
	Working With The Document Object Model	642
	Using The Document Container's Event Object	646
	Manipulating Objects In The DOM	651
	Working With Scriptlets	658
	Where To Go From Here	663
Chapter 21	Server-Side Data Support Techniques	665
	Adding Data Support To Your Server-Side Pages	665
	Using ActiveX Data Objects (ADO) From Active Server Pages (ASPs)	668
	Working With RDS For Client-Side Data Support	678
	Where To Go From Here	685
Chapter 22	Web-Based Solutions With Visual Basic 6	687
	Using Active Documents	688
	Using DHTML Components	693
	Creating Internet Information Server (HS) Applications	698
	Where To Go From Here	705
Part VI	Appendixes
Appendix A	DAO And ADO Reference	709
Appendix B	ANSI SQL Vs. Jet SQL Data Types	711
Appendix C	Web Sites And Support Resources For Access, VBA, And Office 2000	713
	Index	717