Microsoft Access Development

I've worked with Microsoft Access since the 1.0 version.  So I've seen it all.  Well most... Check out the menu for new Access articles.

Think the new 'ribbons' stuff in Office 12 stinks?  You are not alone.  Here is an add-in that will give you back the traditional menus you are used to.

Links

If you want to learn more about Access, a good way is to attend a local users group.  In San Diego, you can go here.

Do you have comments and error handling in all of your Access/Office VBA code?  No?  Pain to add that stuff isn't it?  It isn't if you get the MZ-Tools 3.0 Add-In from MZ-Tools.com.  Make sure you download the right version; the one for VBA. See how I used the add-in to easily add error handling in this article.

Articles List  


Access
Adventures in Access 2007
03/12/2008 - Follow my trials and tribulations as I develop my first, from scratch Access 2007 application. As a veteran Access developer, I have been avoiding Access 2007, but I finally take the plunge. This will be an ongoing, ever changing article documenting my adventure. This will be a look at Access 2007 from a veteran's point of view, so it's not really a beginner's article. Read More...

DSN-Less Connections in Access
05/13/2007 - Still using ODBC DSN's for your linked SQL Server tables? You can save time and reduce maintenance issues by using DSN-Less links. Here's how. Read More...

Error Handling in Access
05/13/2007 - Everyone has their own way of doing error handling in code. I made my method to be convenient and consistent across the application. Read More...

Link Read Only SQL Server Tables in Access
05/13/2007 - How to link SQL Server tables into your Access application so they are read-only and do not cause locking on the server. Read More...