File Recovery Archive

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 business application needs to handle numerous users at the same time. While some experts suggest dumping Access altogether if you have, say 50 to 100 simultaneous users, the choice may be difficult for small businesses. Creating another application from scratch that too with a different database platform can prove costly. In such scenarios, you should look at using MS Access in an optimal manner and a well-designed Access application can even handle 200 simultaneous users at one time. Just follow the roadmap below to ensure your Access application can handle multiple users at the same time

Design an Access Application that Can Sustain 100 Simultaneous Users

1.      Split the Access Database and use privileges to restrict write access.

If you are looking to support numerous users, it is quite likely that you are using a split access database. In case you have not, immediately split the database with the front end user interface being deployed on user machines while the backend data repository been kept on a different machine. In case you need help on how to split your Access application, try visiting Microsoft’s support site. 

In split database model, use user privileges to grant writing authority to a limited number of users while allowing read authority for all else. Not everyone in your office may need to input data and thus you can limit these people to view access only. 

2.      Design effective input forms and use proper validations

The amount of data that moves during concurrent sessions can affect the performance of an Access application. Ensure the input forms are well designed and do not contain useless data fields. If possible avoid attachment options in input forms.  

3.      Restrict size of graphics

In case you are using images, especially inputting image files, make sure you restrict their size.

4.      Enforce correct Record locking options

In a multiuser Access solution, it is critical to choose the right record locking option. Choose the default open mode as Shared while you need to record locking default to Edited Record.  To access these options visit the File Menu and go to the Client Settings in the Options tab.

5.      Adhere to standard Access optimization best practices

To ensure the application works perfectly, standard Access best practices need to be followed. They include the use of temporary tables wherever needed, smaller indexes and regular compacting of the backend database.

Prepare for Contingencies

When your application is being used by several users at any point in time, chances of errors and database crash is always present. Despite your best efforts, you may not be able to prevent an MS Access crash. To avoid incidents of data loss due to corrupt accdb or mdb errors, consider keeping an Access recovery tool like DataNumen Access Repair handy.

Author Introduction:

Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql fix and excel recovery software products. For more information visit www.datanumen.com

Be the first to comment

In this article, we highlight 7 key reasons that make Tell Me exceptionally popular with Access Users.

In 2016, the latest iteration of MS Access was rolled out with an array of new features and improvements. Prominent amongst them was the Tell Me Box which appeared at the top of the interface and inquired the user about what he or she was looking to do. For example, if you are looking to insert images, just need type in the same and you would be directed to the specific command section on the interface. The tool has become a rank favourite with many Access users and we have listed 7 reasons why it is riding the popularity charts.

7 Reasons Make "Tell Me" Feature in Access Popular

1.      Its Saves time by getting appropriate answers

The Tell Me box is designed to help save which you would unnecessarily waste in figuring out answers. While it may not give accurate answers in every case, our experience with it is quite good. It is able to give relevant answers related to normal access tasks and is quite intuitive.

2.      It is Easy to Locate and Use

The Tell Me Box is available by default on the top bar. It can be accessed with ease and one just needs to enter what he is looking for to get an answer.

3.      It offers intelligent suggestions

The feature is capable of providing intelligent suggests. For example, if you enter a wish “make font color red”. Now in case you have not selected any text for the same, it will turn on the specified color and any text you type at cursor would be red. Similarly, if you are keying in a command or formula the feature will list down a bunch of suggestions for you to choose from.

4.      It attempts to understand natural language in some cases

The tool uses a mechanism to understand natural language commands. So words like “Make” and “Set” are interpreted in similar fashion

5.      It works with Voice Commands in Windows 10

If you are using the Windows 10 OS, you can use voice commands to work with the Tell Me feature.

6.       Can connect you directly to Smart Lookup and Help

In case you are looking for more information instead of a command, the feature can connect you with Smart Lookup feature, thereby allowing you to discover your answer.

7.      The feature is available across most office programs like Word, Excel, and Visio etc.

A great part of this feature is that it is not limited to Access only but is available with other MS Office programs. Thus if you become adept at using it in Access, you are likely to find beneficial while working with other MS Office programs.

While MS Access 2016 can be rightly termed as an evolved piece of software, it still remains quite open to incidents of Access corruption. Thus the need for a tool like DataNumen Access Repair that can repair accdb or mdb database files is always there, especially if you are using the software for business.

Author Introduction:

Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql recovery and excel recovery software products. For more information visit www.datanumen.com

Be the first to comment

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 end is placed across different user machines while main data repository is stored on a different machine or backend. Quite expectedly, a majority of vulnerabilities arise from the front end interface deployed at user machines. To help you address such issues, we have listed 5 practical tips to secure MS Access front end.

5 Key Ways to Secure the Access Front End

1.      Consider using a Custom Ribbon for the Front End interface

If you opt for creating a custom ribbon for your users, they would not be able to access Commands typically available on the standard ribbon interface. In other words, you would essentially restrict them to the minimum things that may need to operate the application, thus securing it.

2.       Control the User access to the application

It makes great sense to control the user access to the application. In your database, try to keep a table containing names of all Window’s usernames that can use the application. When the application starts up on a client machine, ensure that it checks the network username and is matched with the records present. If the usernames do not match, ensure the application gets closed automatically. 

3.      By default always place a compiled version of Front end on client machines

By using a compiled version (like Accde), you can effectively lock down a variety of objects from being modified by users. Nor can users open up forms in design view, thus limiting their option to compromise the data, even unintentionally.

4.      Consider disabling Special Keys and Shift Bypass

When you are looking to secure the front end, it makes immense sense to disable the shift bypass option. Similarly consider locking all special keys, especially the ones that bring out the VBE editor.

5.      Use folder permissions effectively

MS Access stores data in flat files. Quite naturally you need to protect the folders hosting these files, including the one containing temporary files by applying the relevant permission controls.

Dealing with Situations beyond your control

Despite doing all that is possible to protect your MS Access data, you may still end up with a corrupt database file. In rare cases, the cause for Access corruption can be as insignificant as a logical error arising out of a failed update operation. Given that Access errors are going to happen at some point of time, the best way to protect your data involves getting hold of an accdb recovery tool like DataNumen Access Repair. Whenever you encounter a database crash, just use this powerful utility to get back your data in perfect shape, that too in quick time.

Author Introduction:

Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql repair and excel recovery software products. For more information visit www.datanumen.com

Be the first to comment