Jun 06

Consulting Services and Custom Software Solutions for Large Businesses

Serving Large Organizations and Public CompaniesFMS Professional Solutions Group logoSince 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.

Jun 01

Published on Enterprise Features: Microsoft Access Is Underrated–Your Hatred of Access Is Largely Unjustified

Microsoft Access Enterprise Features Microsoft Access

The Enterprise Features web site highlight’s FMS President Luke Chung’s discussion about why Microsoft Access is underrated and hated in large enterprise organizations. “Haters Gonna Hate”

He discusses the dynamics of IT departments in large organizations and their natural conflict with the needs and budgets of information worker. He also shows how organizations that understand the strengths and weaknesses of Microsoft Access can leverage its power for competitive advantage, and how to structure service levels to do so.

May 31

Microsoft Access Database Scalability: How many users can it support?

Microsoft Access 2013What’s the Maximum Number of Microsoft Access Users?

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 flatly refute any suggestions that Microsoft Access users are limited to around 30. We’ve run many tests and have never seen that kind of degradation in performance. It is a myth from Access 2.0 days that was eliminated with Access 97 almost two decades ago.

A poorly designed Access database won’t support two users, but a well designed Access solution can support hundreds of users. Of course, what matters is the number of simultaneous users, and what they’re doing.

At Least 200 Simultaneous Microsoft Access Users on an Access/Jet Database

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 users 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.

Migrate Back-End Access Database to Microsoft SQL Server for More Users

Microsoft SQL ServerIf 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:

Total Access StartupSimplify Support for All the Users of Your Access Databases

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

This allows you to centrally support a large number of Access users across your network and ensure everyone is using the latest version of your application. It also simplifies the migration from one version of Access to another.

Additional Discussions

MicrosoftThis topic was also discussed on the Microsoft Developer Network here:
Microsoft Access Database Scalability: How many users can it support?

Aug 20

Deploying Microsoft Access Databases Linked to SQL Azure Databases

Microsoft AccessSQL Azure A few weeks ago, I discussed how Microsoft Access could link to databases hosted on SQL Azure. Here's a new paper discussing How to Deploy Microsoft Access Databases Linked to a SQL Azure Database. Details on how this works and how to distribute your databases are covered. The people who receive your database don't need a license of SQL Server but do need to have its ODBC driver installed on their machines.

Here's the original blog on Microsoft Access, Azure and SQL Azure.

Jul 23

Microsoft Access and Cloud Computing with SQL Azure Databases

Microsoft AccessSQL AzureWe 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.

Windows AzureWhile 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: