Microsoft Access Database, like with many of the other Microsoft applications is very versatile and can be a valuable asset for businesses (of all scopes). However, unlike MS Word and MS Excel which are normally used in the workplace for the day to day and general running of the business work flow and then can be also used to support MS Access at a level that complements other systems, Microsoft Access Database is the kind of application that takes office applications to the next level and can be used in various ways depending on the type of business and its needs.
If you are regular visitor to this site or have used this application, you will know Access primarily used to store information; data in a structured manner. While in most cases fort small to medium businesses, a stand-alone or shared database is manageable and can even be scaled up and can be connected to something like SQL Server or Azure for the larger organisations or a level of complexity that a stand-alone may struggle to provide.
There are a few operations and functions that you may wish to carry out in an Access application that might not be executed on a regular basis yet will need to be completed at certain times or events especially while in the development phase and before it’s being released to a live environment.
One task maybe the need to permanently delete an Microsoft Access database and removing it from the Windows Registry entries are just two examples.
If you have just created a new database, sometimes you would need to delete it and start from scratch all over again. There are several reasons why you would be required to do this, but here we are only going to focus on how it is done.
The steps for deleting a database are simple — all you have to do is delete the Access file via the normal Windows Explorer. However, this will not remove it completely as it remains in the documents library as ‘accdb’ files (or in other formats you have chosen).
To totally delete the database in the Access file listing, you should erase it from the registry too.
Warning: Before you carry out any manual editing to the Windows Registry, please make a back up of the Windows Registry first (just in case!). In some case, you may not have access to this area and it’s assumed that you an administrator that can open this application.
Follow the steps to below:
- Click the Start button and type ‘regedit’ in the search field.
- Locate the sub key that holds the item/s and click it to view the files inside.
- Right-click the file that you want to delete and choose Delete. This will prevent it from appearing in the Access file list.
Why You Should Remove an Access Database from the Registry
Storage space is one of the things one should consider when using applications with big file sizes. When deleting an item, sometimes parts of it still sit in the system, occupying crucial system space. For this reason, it is necessary to delete them and free up space.
Deleting an unwanted ‘accdb’ database from the registry will free up only a small space. However, if several unwanted databases are stored in the registry, you will be able to free up greater space by removing them all.
You will also avoid potential conflicts and naming conventions if adopted though many instances are created to generally avoid this, nothing is assured. At a level where VBA programming is being deployed, if the code procedures utilises the Windows Registry this can cause errors and corruption that may affect Windows elsewhere so generally cleaning up the Registry is just good practice.