The HotMommas Project and Professor Kathy Korman Frey are featured in a recent Washington Post article. It is about the GWU Women's Entrepreneurial Leadership Class, the Hot Mommas Project (as mentioned previously on our blog), and all the reasons why these educational initiatives exist.
Today, April 13th, 2009, at 12pm EST you can participate in a related online chat at the Washington Post's website. Professor Frey will be there to answer questions and lead the discussion.
Recently, we published an article describing how to Synchronize Two Related Subforms on a Microsoft Access Form. In that article, we mentioned when setting the master link field of a subform, you should always reference the control rather than the field name. We didn't mention why and received some inquiries, so this new article covers when and why that's so important. It includes a database with examples showing how a reference to the field instead of the control could cause users to not realize they're editing the wrong linked records, or adding and deleting records linked to the wrong master value. Read more in the article on why Microsoft Access Subforms Should Reference the Control Rather than Field for Master Link Fields
There are many experienced Microsoft Access developers who continue to resist the migration to Access 2007. While there are some changes that are cumbersome, there are many new features that justify the migration. With Access 2007, you can create applications with features that in many cases would be impossible to provide in prior versions. Here are my Top Features of Microsoft Access 2007 That Aren't Available in Prior Versions.
Over the years, I have had an ongoing discussion about how Microsoft Access best fits in an organization's database strategy. Similar to how some Excel files evolve beyond the capabilities of a spreadsheet and move to Access, some Access applications grow beyond the features of Access. Recently, I was interviewed by Microsoft’s Architect Evangelist Dr. Zhiming Xue on dealing with Access Database based solutions and the challenges of migrating them to SQL Server. Watch the 22 minute video and read more about Migrating Microsoft Access Databases to SQL Server. Let me know what you think.
Our list of all the internal Microsoft Access error numbers and error descriptions now has a database with the descriptions by Access version in a table. Use it as a reference or for your own lookups across Access versions.