This book covers what Access developers need to know about SQL Server, covering the two most common versions of both products: Microsoft Access 97 and 2000 and Microsoft SQL Server 6.5 and 7. The author offers his own tips and techniques based on practical hands-on experience. The resulting book teaches developers how to accomplish their goal without over-simplifying the migration process. Further, it includes detailed information on how to work with SQL Server outside of the Access environment and how to design efficient SQL Server databases. It outlines the planning involved and helps developers make educated decisions along the way.

Russell Sinclair is an MSCD and the owner of Synthesystems, a technology consulting firm specializing in Visual Basic, SQL Server, and Microsoft Access development. Russell is the senior systems architect with Questica, Inc., a company specializing in software for custom-design manufacturers, and a contributing editor for Smart Access. In addition, he has extensive experience in Access and SQL Server development.