Programming Microsoft Visual Basic .NET for Microsoft Access Databases

Provides programmers with the practical details they need to create or rewrite Microsoft Access?based client applications using Microsoft Visual Basic .NET and the Microsoft .NET Framework.

User review
Not as Advertised
I have been working in this profession for 30 years and have migrated from COBOL to VB-3, to VB-6, and now to VB.Net. The title of this book is `Programming Microsoft Visual Basic.Net for Microsoft Access Databases.`
When I started reading the book it began with very basic VB for the first 128 pages. Then once you do get into the VB sections of the book, there is a lot of repetition and not all of MS Access/VB programming is covered. Everything is done using embedded SQL commands. No raw access to MS Access. Try and find an INDEX change, or a SEEK command.
Rick, you should publish a second book and finish the topic and send it to everyone who purchased this book free.

User review
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.

User review
Decent, but confusing.
I'm a brand new developer using VS.NET, and having never used Visual Studio before I've grown very tired of every single book on .NET
spending %60 of their time explaining how it was done in Visual Studio 6, and how it is done in Visual Studio .NET. This book isn't much
different except that I see a shocking amount of emphasis on the `old` ADO method of data access. In fact, if I read this correctly,
there is more written on ADO/ADOX than there is about ADO.NET.

This is about the 10th book on .NET that I've purchased and every one so far (especially those from MS Press) spend 2-6 chapters talking
about .NET, what it is and why is is so bloody terrific. Book authors, PLEASE, lets stop introducing and re-introducing the same stuff
in EVERY .NET book! Write a `Beginning .NET` for all that stuff and save your readers some time!

Overall my opinion is that this book is mediocre. What this book is is a general .NET book with an
emphasis on database programming (albeit with the `old` ADO stuff).

In short, I'm glad I bought it used for only $10.

User review
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.

User review
Security
Nice walkthrough of setting up database security (MDW file). Only reasonable source I found for this.