Professional SQL Server Devel Opment with Access 2000

by Rick Dobson

This text deals with the many issues involved in making the transition from Access to MS SQL Server. While Access (part of the Microsoft Office suite) has long been the small business database of... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1861004834
• ISBN13: 9781861004833
• Release Date: September 2000
• Publisher: Wrox Press
• Length: 813 Pages
• Weight: 3.10 lbs.
• Dimensions: 1.8" x 7.2" x 9.1"

Customer Reviews

Outstanding resource for making the transition to SQL Server

By far the best book I have seen regarding the difficulties encountered when moving an Access application to SQL Server. Until reading this book, I couldn't figure out why my Access queries that were 'converted' into Stored Procedures could not reference each other, why my forms would not work, why the tables weren't updateable (primary keys weren't copied during conversion), etc. All these and many more perplexing issues are clearly explained here. For quickest results, read Appendices B and C, then the first 7 chapters before trying to convert your first Access database to SQL Server.

A professional "getting started" book

I have years of experience in programming but knew nothing about Access, SQL or VBA when I got my latest assignment. I can't stand those 1000 page books that want to hold me by the hand while I build some simple-minded application through eight chapters. I just need to know the basics quick and then see a few examples of some typical tasks. This book is just what I needed to quickly get me up to speed and working on my own application. There are a few minor differences with Access XP (like changed menus) so you'll need a good XP reference also. I recommend this book to any developer that needs to come up to speed quickly on either SQL or Access.

The title says it all... this is exactly what you get!

This book is aimed at the professional Access developer who wants to learn how to tap into the power of SQL Server, or for the professional SQL Server developer who wants to make use of the excellent front-end and reporting capabilities of Access. I found this book helpful and I don't fit either of the above categories!Rick Dobson explains in a clear and easy-to-understand manner everything that we need to get started... and then some! Everything from installing the database engines to publishing Data Access Pages on the Internet is covered. Provided that you have some experience with database development and/or programming, you will find this book to be one of the most valuable in your collection.

Lifesaver!

If you need to upsize an Access database to SQL Server, this is the book which will solve all the little problems you might have. Not only does it talk you through installing all the necessary software, but it also walks you through just about every process you are going to perform in getting all those Access objects converted to Project form.If you are new to ADO, the book contains an excellent primer to the subject to get you started, although you might want to consult the Microsoft documentation for some of the more in-depth stuff. Speaking personally, this book has served as my bible in upsizing a 240-user Access database replicated over 7 sites to SQL server. If we found it useful, you will too. Get it.

A Programmer's Guide

This is a book that takes you to the heart of Access 2000 and SQL Server, unlike boring syntax reference manuals. The author's style and presentation guide you, at a comfortable pace, from installation steps at the beginning, to development in Access and SQL within the first few chapters. A must read for developers and want-to-be developers. Numerous examples fill the pages of this programmer to programmer quide. Within the first couple of hours after reading this book, I was able to dive right in to SQL 7.0 development using Access 2000 project as a front-end development tool. I have spent many hours attending online seminars and reading reference maunals, this is the first book I have found on the market that answered nearly all of the development questions I have had. Thank you, Rick Dobson, for taking the time to put together one of the best development books on the market for your fellow programmers.