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.

Mercer Consulting, a global provider of human resources services, chose FMS to enhance an existing application for deployment to their multinational clients. See how they leveraged our commercial software development experience to create a professional quality solution with many enhancements including language localization:

"Although we had ambitious goals and increased the scope mid-stream, this was still one of the smoothest software development projects I've seen. FMS's requirements gathering was flexible and efficient, with helpful quick prototyping to facilitate our decision making. The technical development work was always fast, creative but focused, and thoroughly tested....And project management was a breeze, with thorough monthly tracking and the project coming in ahead of schedule and under budget."

Read more in our joint Case Study: Leveraging our Commercial Software Development Expertise

Additional information on our Microsoft Access Development Services 

We are very pleased to announce the creation of our new (and free) Microsoft Access Developer Help Center. It contains our many popular papers with tips and techniques for becoming a better Microsoft Access developer, programmer, and administrator. It covers the whole life cycle from strategic planning of how MS Access fits, database and table design, form and report tips, programming do's and don'ts, deployment, best practices, performance tips, etc.

This follows our recent Microsoft Access Query Help Center that's been well received, and our Microsoft Access to SQL Server Upsizing Help Center. 

We welcome any feedback on what we've put there and suggestions for additional content that would be helpful.

Since our beginning in 1986, we've served large organizations with our leading-edge solutions designed to help people make better data-based decisions. Whether it's on PC desktops, networks, the Internet, and more recently mobile devices, we recognize you need to have the data you need, where and when you need it, in a format that helps you make decisions and avoid mistakes. We also understand the challenges of balancing application functionality with the cost and requirements of regulators, auditors, and enterprise IT.

Our general philosophy is to quickly create sophisticated solutions built on a solid database foundation. Designed to scale and expand, our solutions evolve as your business demands it. Sometimes we can anticipate future needs in our design, but more often, the application evolves based on unforeseen events such as changes in the economy, regulations, new products and customers, or competitive pressure. With our staff of experienced developers, we can quickly adapt our solutions to meet your needs. Rapid development and deployment, fail quickly and cheaply, and water and nurture the seeds that grow and justify additional investment.

We understand the needs of large organizations and deliver the quality you demand. FMS products are used by tens of thousands of customers in over 100 countries including 90 of the Fortune 100.

Learn more about our experience and services to large organizations in our new page Consulting Services and Custom Software Solutions for Large Businesses.

To find out how we can help your organization, please contact us for a Risk-Free Assessment.

There is a persistent myth that Microsoft Access Jet databases can only support 20 or so users. Here's my response to a recent inquiry:

I question the data for the limitations on the number of Access users being around 30. We've run many tests and have never seen that kind of degradation in performance. It's a myth from Access 2.0 days that was eliminated with Access 97 over a decade ago. A well designed Access database can support hundreds of users. Of course, what matters is the number of simultaneous users, and what they're doing.

If everyone is just viewing data or entering data into a table, that takes very little work and a large number of people (well over 200) can be supported. People cannot type faster than what Access can handle. If they are all running massive reports and queries with data updates, that can still be done but performance would be an issue which applies to any technology, so testing and optimization would be necessary.

If the back-end database is in SQL Server rather than an Access/Jet database, the number of users can be practically unlimited if each user has their own front-end copy of the Access application. Performance issues still apply based on what they are doing. In some cases SQL Server is slower than Access, so it is important to understand the situation before thinking SQL Server is the answer.

All that said, any Access application that is distributed to others with shared data should be a split database design. Here are a few resources we've written:

• Splitting Microsoft Access Databases to Improve Performance and Simplify Maintainability
• Significantly Improve the Performance of Microsoft Access Databases with Linked Tables

We also offer a commercial product for enterprises, Total Access Startup, that helps with the distribution of databases to each user's desktop and launching the right version of Access.

Read our new paper on using Terminal Services and RemoteApp to Extend Microsoft Access and Other Windows Applications Over the Internet.

One of the features of Microsoft Windows Server that is increasingly popular over the last few years is the Terminal Server and more recently RemoteApp. With few exceptions, most Windows applications work within a Terminal Server environment. By doing so, your investment in existing applications, and the power of Windows desktop features and interoperability, can be exposed over the Internet.

This is particularly powerful for database applications such as Microsoft Access since it eliminates the need to send large amounts of data over the Internet for Access to process and users do not need to install Access on their machine. With RemoteApp, you can set up a terminal server experience where your users can only run your application without running other applications or browsing your network. Easily web enable all your desktop applications.

FMS President Luke Chung will be attending and speaking at the three day Microsoft Access conference sponsored by the Portland Oregon Access User Group.  Join him and other guest speakers including Alison Balter from InfoTech Services Group Inc., Armen Stein from J Street Technology, and Kevin Bell from Microsoft.

Luke will be speaking on the following topics:

• FMS Products for Microsoft Access Developers and How they Make You Money
• Microsoft Access and Azure: Working in the Cloud
• Microsoft Access Disaster Recovery Plans

For complete details visit PAUG 2011 Database Designer Conference and see you there May 14-16

File server databases like Access/JET MDB and ACCDB files need to be periodically compacted and repaired for optimal performance and to minimize database corruption. This also eliminates database bloat that can occur as data is added and deleted in the database. Here's a Microsoft Knowledgebase article that discusses some of the issues.

Microsoft Access databases can be manually compacted from the Access menu. Unfortunately, over the last few versions of Access, the location of this command has moved around driving Access many users and developers crazy. Read this paper for how performing this critical system administration task across all versions of Access:

Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by Access Version)

If you create or take over a Microsoft Access application from someone else, you become responsible for the data in addition to the application and its queries, forms, reports, macros, and module code. Unanticipated disasters can occur, so it's important to prepare before they happen. The amount of effort and investment to spend for disaster recovery varies with the value of the application, but some basics apply to all applications.

A Disaster Recovery Plan is much more than making backups of your database. And if your backups are on the same machine and/or hard disk as your production database, that doesn't qualify. 

Read our paper on Creating a Backup and Disaster Recovery Plan for Microsoft Access Database Applications  for ways to limit your risk and headaches, while providing a professional solution for your end-users, boss, and clients.

We at FMS are very excited about cloud computing and started developing solutions using Microsoft Azure including SQL Azure well before it was released to the general public. I feel cloud computing represents the next big platform change in the software industry and the most significant transformation since the introduction of the Internet in the mid-1990's. It will transform the internal hardware, application hosting, and data storage business the same way electric companies eliminated most organization's need to generate their own electricity.

While there's been lots of discussions of Azure with .NET and SQL Server, we also see lots of opportunities with Azure and the Microsoft Access/Excel/Office community. In fact, we're busily working on a way to integrate Access data and files with the cloud. Meanwhile, we'd like to share some tips and techniques for linking Access databases directly to tables in SQL Azure. This opens up huge new opportunities to create and deploy Access databases using a more robust, cheaper, and highly scalable platform that is enterprise quality.

 I look forward to your feedback on two new papers:

• Microsoft Azure and Cloud Computing...What it Means to Me and Information Workers
• Microsoft Access and Cloud Computing with SQL Azure Databases (Linking to SQL Server Tables in the Cloud).

On Monday July 19, I'll be live on the local radio show Start up or Shut up! which covers creating and running a small business.  It'll be from 2-3PM on 1580 AM in Northern Virginia. 

Start up or Shut up! is a LIVE radio show Monday afternoon from 2-3pm on the Big Talker 1580 AM hosted by Mark Bucher & Tom Gregg. More info about the program here About Startup or Shutup

I spent the 4th of July watching the fireworks in DC next to the Lincoln Memorial. It's always a wonderful experience to do that beyond the basic joy of watching cool explosions. Sitting by the reflecting pool with friends and family let us reflect on what a wonderful nation and concepts our founding fathers created by prioritizing the freedom of the individual.

Over the past few months, I've had the fortune of participating in our democratic system much more than usual. 

I was recently appointed to the Fairfax County Information Technology Policy Advisory Committee (ITPAC) on behalf of the school board, which is giving me insight into the challenges our county and all local municipalities face with providing services to its citizens. Some of the problems are quite fascinating and complex. I've only been to one meeting and we won't meet until after the summer, so we'll see what comes of it.

Late last month, I was invited to participate in a lobbying effort on Capitol Hill as part of the Association for Competitive Technology. I did this twice almost 10 years ago, so it's been quite a while. ACT gives small technology businesses a voice amid the battle among the large players, and brought in participants from across the country for a one day blitz. It turns out that we as a group are very under-represented on the Hill and were warmly received at all the offices we visited. All elected officials want to support small business owners in their districts, but don't seem to meet them too often on the hill. I was very pleased to participate in small group meetings and had a chance to meet my Senator Mark Warner (D-VA, very impressive as he really understands the technology industry) and Congressman Moran (D-VA). We also met the legislative aides for Sen. Hatch (R-UT), Congressman Connolly (D-VA) and Wittman (R-VA), and Speaker Pelosi (D-CA). Unlike the others, the speaker's office is in the Capitol building and was an interesting maze to get to both physically and through security.

The general message was to make sure they considered the impact of their decisions on small businesses and how unintended consequences of their decisions may impact us. Whether it's regulating the internet, net neutrality, cloud computing, privacy, international laws, taxation, patents, etc., a lot of issues affect small technology businesses. Considering the impact of small business on employment in this country, it's critical that they don't create more problems than they solve.

I don't know how much of an impact we had, but it was gratifying to walk the halls of Congress and see how they operate. There are a lot of challenges facing our country and world. Technology holds the promise that it can help us increase our productivity and ability to address those needs in a meaningful way at a reasonable cost. I hope they continue to foster an environment that allows technology, innovation, and entrepreneurship to prosper for the common good.

We have a long history of leveraging existing data to improve decision making and communications.

Many of you are already familiar with how our Total Access Emailer program automates the sending of personalized emails with recipient specific data and reports. This amazing product lets you leverage the power of your data to significantly improve how you communicate with your contacts.

With our experience creating Total Access Emailer, our Professional Solutions Group has helped many organizations incorporate the product and implement advanced, custom features.

We've also taken this technology to the next level by creating web sites to host files rather than emailing them to your contacts. If you're interested in learning more about how we can extend your Windows desktop files to the web, please let us know. We can make it easy for your contacts to privately log in and see their files.

Can we help you with a project? Contact us for a Risk Free Assessment