Microsoft Access Database: How To Completely Remove A Database ?

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 Serveror 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 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:
  1. Click the Start button and type ‘regedit’ in the search field.Microsoft Access Database
  2. Locate the sub key that holds the item/s and click it to view the files inside.Microsoft Access Database
  3. Right-click the file that you want to delete and choose Delete. This will prevent it from appearing in the Access file list. Microsoft Access Database

    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.

Comments

Post a Comment

Popular posts from this blog

Microsoft Access Queries: An Action Query

Image
You use this type of query to change data in tables, saving the need to manually edit records or use any of the manual tools namely,  Find  and Replace . Examples for this action could be to reset data, change prices, increase volume and correct data migration and population issues. One of the more commonly used examples is to carry out some sort of calculation and change prices for a range of products. The above example increases all products for UK suppliers by 10% using the  [Unit Price]  field containing the original price value multiplied by 1.1 (an increase by 110%). Just remember, this is an action query which means changes to any data values cannot be reversed once actioned which is why you should normally see a warning first. However, it is always a good idea to take a copy or back up of your data files before running  Microsoft Access VBA programming  of this nature. There are many other types of queries too and the more you know about Access queries, the more f
Read more

How To Run Microsoft Access On A Mac PC Using CrossOver Software – Alternative Options

Image
Firstly, let’s clarify that Microsoft Office for Mac does not include the  microsoft access database  application which is why we have to take such steps. The alternatives and work around could include: 1.  Using the free runtime version for an exectuable file only or a third party web app which is now available for the iPad so you can load Access as a viewer only should you need to just read information. 2.  Installing VMWare (or similar) which is a virtual image software tool that creates a separate instance on your Mac PC and therefore can have several versions as a quick way to restore a default environment. However, it will require you having a licenced copy of Microsoft Windows operating system whereas CrossOver has this already included 3.  Using some sort of remote access software like LogMeIn or SplashTop (which there is a free version. There are others too but the two mentioned I have used are very effective indeed but will require a live internet connection to a
Read more

Microsoft Access Tutorial: Creating A Many-To-Many Relationship

Image
Microsoft access tutorial In a relational database, a many-to-many relationship exists when a record in one table can be referenced by one or more records in another table and vice versa. You need to have two or more tables to create relationships. To link these tables, you will have to create another table (a third) which will be your interceding or junction table. Here are the steps again in creating a third table: 1.  Go to the Create tab. 2.  Click on Table Design. A new table will be opened. 3.  Create two fields (plus any additional supporting fields). NOTE:  The two key fields are going to be the primary keys from the two tables that you have created which are in effect known as secondary or foreign keys (duplicates OK). To identify the primary key from a table: Click on the existing table and select View on the upper left corner of MS Access. You can identify the primary key when you click on one of the fields and see the Primary Key button, right next to the
Read more