Posts Tagged 'Access'

How to Design an Access Application that Can Sustain 100 Simultaneous Users

While theoretically Access can support 255 simultaneous connections, in reality, bottlenecks arise at even 20 to 25 simultaneous users. In this article, we plan the deployment in a manner than 100 users can be simultaneously supported. Many small businesses tend to grow over time both in business size and employee count. With Access being the preferred database for small business users, there are numerous cases where people using Access in their company suddenly found that their line of...

Read more »

5 Key Ways to Secure the Access Front End and Reduce Chances of Data Breach

In MS Access, despite encryption of underlying data, the passwords get stored in the front end in plain text and can be extracted. Learn 5 ways to secure the front end and avoid data breaches When you are using an MS Access application for operating a line of business application, chances of a data breach is always there. Thus it is imperative that you ensure the security of the application. Now, most multiuser Access application are based on a split database model, wherein the Access front...

Read more »