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.
Chapter 8, “Using Queries to Get the Most Out of Your Data,” covers how to optimize your queries and create query objects by using VBA.
Chapter 25, “Developing SQL Server Projects Using ADPs,” discusses the client/server model in more detail by further describing the capabilities of Access Projects.
18.224.149.242