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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access