Programming Microsoft Visual Basic .Net for Microsoft Access Databases

by Rick Dobson

Book Overview

The Microsoft .NET Framework represents an exciting new world for developers who work with Microsoft Access, Visual Basic, and Visual Basic for Applications. This book provides complete, practical... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0735618194
• ISBN13: 9780735618190
• Release Date: January 2003
• Publisher: Microsoft Press
• Length: 656 Pages
• Weight: 2.80 lbs.
• Dimensions: 1.6" x 7.4" x 9.0"

Customer Reviews

A book that does what it sets out to do.

As I read the review that compained about the heavy use of ADO rather than ADO.net in the first part of the book, it seemed to me that the reviewer missed what Dobson was trying to do. This book really teaches two subjects--VS.Net and ADO.Net as it applies to Access. I appreciated that he used the old familiar ADO while discussing the new, unfamiliar VS.Net, and then, when the reader should be comfortable with the first topic, began to teach the second. I think he did a good job of laying the groudwork for using Visual Studio.net before then introducing the complex topic of switching to ADO.net. I would recommend this book for anyone transitioning from VB or VBA to .net using Access databases.

Good transition from VBA to VB.NET

The target audience for the book is, quite simply, Access developers who are accustomed to VBA and/or VB 6. This book serves a good purpose, as the .NET materials I have seen to date all refer to SQL Server in their examples; they acknowledge Access, but fail to show its uses. I am not crazy about seeing "old" technology such as ADO used in some of the examples, but for a book of this nature (transitioning between coding languages) I guess that is inevitable that some old/new information would be included at various points.Do not purchase the book if you're intending to use the built-in VBA capabilities of Access or other Office applications -- that's strictly not covered. What you will find, though, is a good sense of how VB.NET operates on its own, and how to create applications that draw upon the data stored in your Access databases.This should be a good base point for someone who's developed in Access, and wants to investigate moving forward; it should be a means to an end, rather than the destination itself. Additional reading on ADO.NET and classes will be helpful, I believe, to continue fleshing out knowledge to be truly effective in your work, but this book does a good job of introducting those concepts.

For Access Developer transforming to VB.NET Developer

This book is definitely for MS Access developer. All examples use Northwind.mdb. The first part introduces Visual Studio .NET environment using many practical MS Access examples I've used in my application systems. The 2nd part deals primarily with VB.NET capabilities. The 3rd part introduces you to ADO.NET using MS Access with many practical examples like add, change, delete, master/detail. The remaining chapters talk about ASP.NET and XML with MS Access. I've read VB.NET books and taken VB.NET course but don't have the confidence converting my applications. With this book, I'm all set to go. A must have for all MS Access developers ready to move to the .NET world.

Programming VB.NET for Access Databases

I am the author of this book. I am submitting this review because I believe there's a confusion about what's in the book. This is, in part, because the title changed three times on the way to its final release, and some book sellers didn't get the last change. For example, the book title on this page is correct, but the book cover shows the wrong title. I write this review to give potential readers a good idea about what's in the book and why the content is important for those creating solutions with Access databases.I want to begin by saying this book is about Programming Visual Basic .NET. My goal is to introduce you to the .NET Framework through Visual Basic .NET. As result, the coverage is broad without drilling deeply into any one area. For example, you'll find 3 chapters on VB.NET programming, 2 on Windows Forms, 3 on ADO.NET, 2 on ASP.NET, and 1 chapter on XML Web Services. In addition, there's an introductory chapter on the .NET Framework and an appendix on XML for Visual Basic .NET Access database developers.The second point that I want to make about the book is that it targets Access database developers. All the database samples in the book, except one, are for Access databases, and every chapter has at least one complete sample -- most have several samples. There is a separate chapter devoted to securing .NET applications for Access databases. To say the book is about Access databases is true. However, it is not about the Access UI. If you currently create solutions exclusively with the Access UI and you want to continue doing that, this book is not for you. However, if you currently program Access solutions with either VBA or VB, then this book is an easy way to transition to VB.NET.I want to close my review by mentioning why I think it so important for Access developers to learn VB.NET. The simple answer is that .NET is coming. Microsoft introduced it in Visual Studio .NET, and then added it to Windows 2003. A Microsoft roadmap explains that the next version of SQL Server will include the .NET Framework. Can Access and the whole of Office be far behind? Beyond the certainty that .NET will be on a growing number of computers near you, there is the issue that now is the right time to learn VB.NET. This is because VB.NET is at the beginning. It can only become richer (more complicated) with each succeeding version. The best time to learn .NET is right now. My hope is that you use my book to help you do that.

Yes. They made a book just for me.

Rick Dobson is usually so darn thorough! He takes nothing for granted. And this book is no exception. As a long-time Microsoft Access developer, what I want to learn is not everything about .NET, but about .NET with Access. This book must have been written just for me. Of course, after I have .NET working well with Access, then I would have a head start moving on to .NET with SQL Server and etc. This book covers Windows Forms and Web Forms in .NET. It covers XML. It covers coding techniques. It covers security. What a great head start I now have on .NET! I'm psyhched, and I'm going to redo my website in .NET and Access!