Microsoft Access is the most popular desktop database in the world with millions of databases; some being mission critical. As such, CTO’s need to recognize and manage these kinds of applications to ensure business success and continuity.
The very worst moment to find out you’ve got a mission critical Access database is when it stops working, with little-to-no knowledge of how to troubleshoot the issue. Therefore, we’d like to cover what you can do in situations like these to ensure individual and business success.
Now that you’ve identified your mission critical databases, follow these best practices:
Maintenance
Maintenance of the Access database consists of doing a compact and repair on your Back End file every 3 or 6 months, as needed.
Your employees will continue to use Access, enable them.
Access can be a great tool in the right hands, allowing companies to leverage its ease of programming and rapid development. With your applications remaining as toolsets in Office installed on your desktops, your employees can successfully learn how to develop and manage Access apps, while fully reaping its benefits.
As a result of its short development cycle, Access is the ‘go-to’ application for productivity improvements. Therefore the time to identify when an Access application is mission critical is before a key developer leaves, or if the system stops working or becomes unstable. IT managers need to be proactive, working with departments to identify databases and document their behavior. Having a strategy in place for dealing with mission critical Access databases will ensure your company can continue leveraging the technology for years to come.
About the Author:
Juan Soto is the President of IT Impact and a leading professional in the industry. He has been named an Access MVP by Microsoft since 2011 and is a frequent author on the official Microsoft Access blog as well as the co-founder of AccessUserGroups.org, where groups of Access enthusiasts around the world meet once a month on a wide range of topics. You can reach Juan at https://accessexperts.com/contact/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.