How to Edit Windows Registry Using Access VBA

Creating and editing the Windows registry is a simple process using the Access VB scripting language. You can easily navigate to a specific key in the registry by using Registry Favorites or Edit>Find. In addition to this, you can use the Reg add and Reg remove commands to add a new subkey to the Registry. Reg export creates a copy of the Registry so you can restore it if something goes wrong.
GetAllSettings function returns two-dimensional variant array
The GetAllSettings function is a Windows API method that returns a two-dimensional array of strings from the Windows registry. The method works with the subkeys HKEY_CURRENT_USERSoftwareVB and VBA Program Settings. The function returns the names and values of the value entries in a two-dimensional array, starting from zero. This method does not work for the default values, which require Win32 API.
This function can also be used to query for files in the Windows registry. The resulting two-dimensional array is an XML file. The text stream can contain one or more rows. The array can also include error-handling code. If a value is not found in the registry, the variable will be uninitialized. The GetAllSettings function returns two-dimensional variant array for Windows registry.

Also Read: Mistakes to Avoid When Starting a New Business

HKLMSOFTWARE subkey contains software and Windows settings

HKLMSOFTWARE stores information on software and Windows settings on your computer. It is organized by vendor. It also stores per-application information, such as the version and installation directory. This makes detecting existing installations relatively simple. The HKEY_CLASSES_ROOT key stores user profile settings. These keys are located in the %SystemRoot%System32config folder.
HKLMSOFTWARE’s policies subkey contains entries created by the Windows system. Windows creates these entries when it sets the Computer Configuration folder in the Group Policy tool. Different versions of Windows support different policy branches. For example, HKLMSOFTWAREMicrosoftWindowsCurrentVersionPolicies subkey stores settings that are specific to Windows 2000.
HKLMSECURITY subkey contains security database of the domain into which the user is logged on
The “HKLMSECURITY” key is usually empty, and links to the Security database of the domain into which the user is currently logged on. This registry hive is maintained by the local system administrators or the built-in “System” account. The kernel uses this data to enforce the security policy of the current user. However, there are some differences between the HKEY_LOCAL_MACHINE and HKEY_CURRENT_USER.
The HKLMSECURITY subkey is located under the ‘Services’ folder in the ‘Services’ directory. It stores data for the services and drivers that the operating system uses. It is important to note that the security database of a domain can be modified by the “SYSTEM” subkey. If the security database is changed, it may be infringed upon.

Also Read: Why Digital Marketing Is Important for Your Business

System Restore


You may be wondering how to use System Restore in Access VBA. If so, you will want to open the config file in Visual Studio. This will open up a System Restore window. Click the ‘Choose a different restore point’ option to choose a different time and date. Be aware that this option will not work if you installed any programs after the date and time you chose.
If you haven’t tried this method yet, you should. First, open the Run command by holding down the Windows and R keys. Type “regedit” into the box, then click OK. Double-click on the UninstallString value to copy it. Then, paste this value in the Value Data box. Next, you can click ‘Uninstall’ to remove the microsoft access VBA software.

Also Read: How to Enable BTRFS Filesystem Compression

Automated System Recovery


If you’ve ever experienced a hard drive failure, Automated System Recovery (ASR) can help you get back on track. The ASR backup wizard automatically creates a floppy disk or a copy of your system partition. You can also use a file, tape, or hard drive. In addition to local disks, ASR can also back up your system partition to a shared network folder or removable disk.
In order to use the Automatic System Recovery wizard, you must have three setup disks and a tape backup created by the Disaster Recovery Preparation Wizard. The ASR wizard will guide you through a few steps, including creating a new system disk. You should run the backup before you make any changes to the configuration of your computer. It will take up to an hour for the ASR disk to back up your data. Once it’s finished, you can close the Backup Utility.

Asim Boss

Muhammad Asim is a Professional Blogger, Writer, SEO Expert. With over 5 years of experience, he handles clients globally & also educates others with different digital marketing tactics.

Asim Boss has 3446 posts and counting. See all posts by Asim Boss

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.