SUMMARY
Using Access to connect to SQL Server data is a whole new world of development. Keeping this in mind when dealing with your Access application in the beginning can save you a great amount of frustration and work when upsizing down the road. Your knowledge of working with both products can someday save you that big project.
For more information on using Access as a front-end application for your client/server development, refer to the following chapters:
Chapter 2, “Coding in Access 2000 with VBA,” gives an overview of VBA and how to use the commands to their fullest.
Chapter 6, “Introducing ActiveX Data Objects,” looks into the ActiveX Data Objects (ADO), including recordset manipulation and creating database objects on-the-fly.
Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.