Don Spencer (Waterloo, ON, IT Manager of Pano Cap Canada)
On 26-Jun-2007, I published a quick blog entry noting that the developer extensions and the Access 2007 runtime were finally available for download. But the next day, a recall was issued because Microsoft Update would not automatically detect and patch the component. Eric Rucker anticipated that the free developer extensions and runtime would be available within a couple weeks, but we are still awaiting the patched product as I write.
One of the reasons why this is so important to IT managers is that departmental applications are often deployed using the runtime engine, thereby avoiding the extra costs of purchasing a full version of Access for each user. With the runtime, managers can deploy the engine free-of-charge to each user. Then, presumably with a split database architecture in place – each user getting a copy of the front-end with the forms and reports and queries and the back-end residing in a protected share on the server – the manager can set up a SharePoint version control site for subsequent, automatic updates to those distributed front-end copies.
So we will wait. Not just because the tool will save money, but because the tool itself is free! Previously a manager would have to purchase the ADE (Access Developer Extensions) for each developer, usually through the Visual Studio Tools for Office (VSTO). This isn’t such a big deal for larger companies who already have bellied up to the bar in purchasing either individual copies of Visual Studio Professional or Visual Studio 2005 Tools for Office. But now, small- and medium-sized companies can deploy their own custom applications using Access 2007 by merely having an Office 2007 Professional copy for each developer without the larger investment in Visual Studio. And, if they were smart, each of those Access developers would have received a free copy of Office 2007 Professional through attending EnergizeIT in June.
What we should see soon is a whole new cadre of IT managers/developers in small- and medium-sized operations discovering or rediscovering Access as a bona fide platform for custom departmental applications. From novice to professional alike, all the tools will soon be in place at minimal cost to SMBs.
So, if you’ve developed in Access before or if you’re brand new to Access 2007, now is the time to get up to speed or to help those you manage get ready. Here are some resources to consider.
- Thanks to my friend, Ruth Morton, for alerting me to the existence of this menu/toolbar to ribbon Excel file which you can download here.
- In addition to all the resources of a TechNet Plus subscription (such as eCourses and the KnowledgeBase articles readily available on your computer), read “Migration Considerations for Access 2007“.
- The central resource is “A discussion of what’s new in Access 2007″, normally from Eric Rucker.
- Clint Convington covers Access 2007 issues regularly.
- You’ll have to sift through some things, but Roger Jennings and Oakleaf Systems still offer some good advice.
- If you, like me, want to start moving from Access 2003 to 2007, go here first: Access-Freak.com. An Access MVP, Oliver Stohr, has set this site up specifically to ease that transition.
- Another MVP, Jeff Conrad, has a site called Access Junkie all about Access 2007.
- The Microsoft Access homepage, of course, is another place to visit regularly, as is the Access 2007 Solution Center which lists the top issues IT managers are reporting regarding installing, activating, and using Access 2007.
- You absolutely must become a member of UtterAccess too. This discussion forum is not only a great place to get questions answered, it is an incubator of Access MVPs. Get to know them.
- Instead of listing the books, take Erik Rucker’s list and consider his suggestions.
- Consider the forthcoming Advisor Summit on Microsoft Access in Miami from 30-Sep to 4-Oct featuring speakers like Alison Balter, Joe Stockman, Andy Baron, Luke Chung, Ken Getz, Mike Groh, and Peter Vogal.
- Or, if you prefer slot machines to Miami beaches while taking a break from the sessions, consider Office Connections 2007 at the Mandalay Bay on 5-8 of Nov where you’ll hear from Alison Balter, Dan Holme, Douglas Ryan VanBenthuysen, Philip Wiest and Microsoft directly.