Office Solutions

3 Quick Tips to Make Access Reports Available to Everyone including Non-users

In this topic, we look at making Access Reports available to all – including those who do not use Access database or have Access runtime installed on their machines If you are using MS Access as a line of business application, there would be times where you need to share reports with various people including possibly customers, employees and other stakeholders. Now not everyone would have MS Access installed on their systems, so it becomes imperative that you figure out a way to share...

Read more »

How to Recover MS Access Data from a Crashed Operating System

In this article, we look at the scene where the OS crashes, thereby compromising the Access data stored on it. We also look at specialized tools for extracting the Access files. Owing to several parts that go in making a computer work, it is hardly a surprise that a computer OS crash can occur at any point in time. From a hard disk failure to a debilitating issue with system memory can lead to a computer crash. Now if you had MS Access files stored in the crashed system and wish to recover...

Read more »

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 »