There are many, many legacy Microsoft Access databases that need to be supported and enhanced. Often the original developer is long gone and there’s little to no documentation available. Yet, you’re expected to take care of it.
No matter what technology it is, taking over someone else’s work is always challenging. It’s even more challenging if you become responsible for a system that you (and no one else) understands.
FMS President Luke Chung explored this topic during his presentation at the Portland Oregon Microsoft Access User Group Conference. Learn about the issues and techniques we’ve learned over the years to triage, enhance, and support Microsoft Access applications, including migrating and upsizing to SQL Server and other platforms.
Here’s a paper and PowerPoint presentation: Tips and Techniques for Taking Over an Legacy Microsoft Access Database Applications
Longtime client Kathy Korman Frey, George Washington University School of Business professor and GWU Entrepreneur in Residence, has engaged the FMS Professional Solutions Group to enhance her HotMommas Project website.
The site is the world's largest collection of public case studies for entrepreneurial women. It is a community where women can learn from the experiences of other women addressing their businesses, family and personal challenges.
The revamped website is built on Visual Studio .NET, SQL Server with a modern, dynamic interface incorporating our technical and graphic artist resources.
Contact us if we can help you with a similar solution.
Our long time client Kathy Korman Frey, George Washington University School of Business professor and GWU Entrepreneur in Residence, has engaged the FMS Professional Solutions Group again to update her HotMommas Project case study competition website and create another brand new website. Professor Frey has amassed the world's largest public domain collection of women's case studies, and created an environment where these women can share their experiences and challenges of creating and running companies along with juggling family and other commitments in life.
This effort is almost complete and we'll be unveiling the revamped case study competition website as well as the new "sister" site next month. Stay tuned!
One of the challenges most organizations face is how to coordinate communications and tasks among team members and external contacts. With multiple people and clients/projects, emails fly in many directions. People with vital information may be unreachable while customers may be providing information to someone in your organization while others who need that information are oblivious. When someone leaves a team or organization, much of their information is lost.
Over the years, we've helped several clients better manage their emails and treat them like a database. We've built solutions that work with Exchange and Outlook to automatically classify contacts, tag emails, and store the information in a Microsoft SQL Server database. The data is presented through a Microsoft Outlook add-in showing all communications with a contact's firm when you create or respond to an email. The data can also be displayed in the Facebook like interface to make it easy for everyone on your team to know what's going on.
There's no longer a need to look in someone else's Inbox since information is immediately shared between everyone who needs to know (even before the recipient opens their message). Searching for messages is quick and easy, and corporate document retention policies can be enforced.
To learn more about this and other innovative activities of our Professional Solutions Group, please contact our consulting team.
Our paper on Using Terminal Services and RemoteApp to Extend Your Microsoft Access and other Windows Applications Over the Internet is updated. There's more information on implementing this plus how Total Access Startup can manage this through user profiles to let every user have a unique experience.
Our Professional Solutions Group has helped organizations run Microsoft Access application over the web and can even help you use host RemoteApp instances for your users. Contact our consulting team for more information.