Hi FullName,

This message brings you good news from ProgrammingMSAccess.com.  Despite the name of the site, we have for a long time included content on SQL Server, VB.NET, and web technologies including ASP and ASP.NET along with Microsoft Access.  Our focus is on serving those building data-based solutions for themselves, small businesses, and departments in larger organizations.  Those teaching database development and programming to others also report finding valuable content at the site.  Some college professors even adopt the webmaster's books and DVDs for their courses.

This message highlights three topics.  First, we feature a new resource page on SQL Server development.  If you ever work with SQL Server, you'll want to make sure that you do not miss this section.  Next, we give you a heads up about the webmaster's best selling book as well as where you find the last remaining copies of another of his books that is almost totally out of print.  Third, we give you reminders about prizes for joining our Database Developers Group and for signing our Guest Book during the July through September quarter.  Fourth, the message wraps up with a link for an excellent resource on Access security.

 

ProgrammingMSAccess.com Does SQL Server and .NET Too!

The name of our site is ProgrammingMSAccess.com, but we have been featuring SQL Server and .NET content for years.  For more than a year now, we have published a .NET Resources page that offers links to our VB.NET, ADO.NET, and Visual Studio .NET content.  Actually, we have been presenting content longer on SQL Server, and we actually have more SQL Server content than .NET content.

To help you uncover our treasure trove of SQL Server content, we just published a SQL Server Resources page.  This page provides links for code samples, presentation slide decks, articles by the webmaster, a FAQ on Access/SQL Server interoperability as well as book and DVD resources on SQL Server available at our site.  Our SQL Server coverage is exceptionally broad in scope.  You can find content appropriate for VBA developers, T-SQL developers, and VB.NET developers.  We have information on programming SQL Server with both ADO and ADO.NET.

It is our belief that you will find our SQL Server Resources and our .NET Resources pages as sterling examples of why you like ProgrammingMSAccess.com.  Our coverage of these topics is designed to get you started on these technologies in a way that makes sense to typical developers creating solutions for themselves, the department in which they work, or small businesses that need independent database developers.  While some other sites have a way of presenting content that targets just the top 5 or 10 percent of developers, we explicitly aim to present content for the middle 70-80 percent of developers.  However, just because we avoid presenting exotic topics in ways that are difficult to understand does not mean that we avoid important database development techniques.  Our broad coverage of Access, SQL Server, and .NET topics is one important indication of our commitment to serving the broadest possible cross-section of database developers.

 

ProgrammingMSAccess.com is an authored-sponsored site

Much of the content at ProgrammingMSAccess.com comes from books, DVDs, and articles authored by the webmaster.  The site name derives from the webmaster's first book on Access titled "Programming Microsoft Access 2000".  The third edition of this book, "Programming Microsoft Office Access 2003", is my best book ever on Access.  The book is exceptionally rich in code samples, which have been perfected and added to over three editions of the book.  All the code samples work with Access 2003, but nearly all the samples also work with Access 2002 and even Access 2000.  In addition, there are about 200 pages of superb coverage on programming SQL Server 2000 from Access.  You can learn more about the book from our website, including a table of contents with chapter summaries.

My "Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET" was a surprisingly popular book.  While it is not "officially" out of print, Amazon.com does not have any copies for sale and neither does BarnesandNoble.com.  A popular site called FetchBook has identified a few book resellers who have copies available at competitive prices.  I cannot put the URL for FetchBook in this newsletter because it triggers email filters that will block this message for some newsletter subscribers.  Here's a link to where you can click a link for FetchBook.  Microsoft Press also has been able to locate a few remaining copies of the book.  Click this link for buying the book from MS Press.  You can learn more about the book from our site.  If you do decide that you need the book, I urge you to buy it quickly because supplies appear to be nearly exhausted worldwide.

 

Prizes from ProgrammingMSAccess.com and the Database Developers Group

Over the years, ProgrammingMSAccess.com has enjoyed relations with software, book, and DVD vendors so that we have been able to offer prizes.  Vendors offer these prizes because they want you to learn about them.  Allowing our site to offer their products as prizes is an inexpensive and effective means of getting to know you -- the ProgrammingMSAccess.com site visitor.  Our prize sponsors for July-September include the Microsoft Office team, vb123.com, and aadconsulting.com.

We offer two different ways for you to win prizes.  First, you can just sign our Guest Book.  We are offering five different prizes this way.  We will be selecting winners for these prizes at the end of September.  Second, we offer six fantastic prizes for those who join or re-new their membership in the Database Developers Group (DDG).  For the past couple of years, we have been oversubscribed for DDG prize winners.  However, we have no new or re-newing DDG members for July or so far for August.  Our prizes are among the best ever.  If you join or re-new now, you will almost surely win of two prizes available during August.  There is a modest fee for joining the DDG, but the benefits far outweigh the membership charge.  You can learn about the specific prizes you become eligible to win in August and September from our site.

 

Special Note about one of our prize vendors

Garry Robinson is the webmaster at vb123.com -- one of our prize vendors this quarter.  In addition, he is a widely regarded Access wizard.  The August 22 issue of the MSDN Flash newsletter recently featured a link to a chapter from Garry's book at the MSDN site.  Garry's featured chapter at the MSDN site drills down on startup options for Access database projects.  His in-depth coverage can show you how to protect your intellectual property when you build solutions in Access for clients.   Here's the link to the chapter at the MSDN site in case you missed it.

 

I hope that you found this message interesting.  I encourage you to try some of the links in this message to visit ProgrammingMSAccess.com.  If you have a question about Access, SQL Server, VBA, or Visual Basic .NET, you may well find what you need at our site.  Also, take a moment to forward this message to one or more of your colleagues who may also be able to benefit from our content or our prizes.  If you no longer wish to receive messages from ProgrammingMSAccess.com, just reply with Remove in Subject field.

 

Rick

www.programmingmsaccess.com