Kulsmau informatics

Rescuing Data from a 'Bad Disk' MBR: A Comprehensive Guide

September 19, 2023 0

We've all been there – faced with a computer hard drive labeled as a "bad disk" in the MBR (Master Boot Record). It can be a heart-wrenching moment when valuable data seems lost forever. But fear not! In this guide, we'll walk you through the steps to recover data from a hard drive with a bad MBR using MiniTool Partition Wizard and share our expert tips to get your files back safely.

Step 1: Gather Your Tools

Before you start the recovery process, you'll need a few essential tools:

1.MiniTool Partition Wizard:** This software will be your lifesaver. You can download a free trial version online.
2. An External Hard Drive:** To store the recovered data.
3.A Spare Computer:** You'll need another working computer to perform the recovery.

 Step 2: Connect the 'Bad Disk'

1. Connect the hard drive with the bad MBR to your spare computer. Ensure all connections are secure.

Step 3: Install and Open MiniTool Partition Wizard

1. Install MiniTool Partition Wizard on the spare computer.
2. Launch the software.

 Step 4: Detect and Repair MBR

1. In MiniTool Partition Wizard, select the 'Disk' menu and choose 'Rebuild MBR.'
2. Select the affected hard drive from the list.
3. Choose the appropriate MBR type (usually 'Windows Standard') and click 'OK' to proceed.
4. Click 'Apply' to execute the MBR repair.

Step 5: Scan for Lost Partitions

1. After repairing the MBR, return to the main interface of MiniTool Partition Wizard.
2. Select the 'Data Recovery' feature.
3. Choose the 'Full Scan' option to search for lost partitions and files.

Step 6: Preview and Recover Data

1. MiniTool Partition Wizard will display a list of recoverable files and folders. You can preview them to ensure you're recovering the right data.
2. Select the files you want to recover and choose a location on the external hard drive to save them.
3. Click 'Apply' to start the recovery process.

 Step 7: Safely Eject the External Drive

1. Once the recovery is complete, safely eject the external hard drive.

 Step 8: Restore Your System

1. If you intend to continue using the repaired hard drive as your system drive, you may need to reinstall the operating system.
2. Ensure your system is booting from the recovered drive (if it was your system drive previously

Facing a 'bad disk' in the MBR can be a nerve-wracking experience, but with the right tools and knowledge, you can successfully recover your precious data. Remember to keep regular backups in the future to avoid such situations. MiniTool Partition Wizard is an invaluable tool in your data recovery arsenal, and by following these steps, you can rescue your data and breathe new life into a seemingly doomed hard drive. 

How to Optimize Excel VBA Compiled Software

September 01, 2023 0

 Slow performance and loading time in Excel VBA is very annoying and can be frustrating too. This can be caused by various factors when not considered whilst programming. 

following  are 15 step by step optimization tips to help improve the speed of your VBA-compiled software:


1. **Optimize Code**: Review your VBA code for any inefficiencies or redundant calculations. Use efficient algorithms and data structures to speed up processing.

2. **Turn Off Screen Updating**: Disable screen updating while your code is running by using `Application.ScreenUpdating = False`. This prevents Excel from refreshing the screen after each operation, which can significantly improve performance.

3. **Use Variables**: Minimize the use of direct cell references and store values in variables instead. Accessing cells repeatedly can slow down your code.

4. **Use Arrays**: If you're working with large datasets, consider using arrays to store and manipulate data in memory rather than interacting with individual cells.

5. **Disable Automatic Calculation**: Set `Application.Calculation = xlManual` to turn off automatic recalculation of formulas during code execution and then re-enable it when your code finishes.

6. **Avoid Select/Activate**: Avoid using `Select` and `Activate` methods, as they can slow down code execution. Instead, work directly with objects and ranges.

7. **Limit Worksheet Changes**: Minimize the number of changes made to worksheets during code execution. Each change can trigger recalculation and screen updates.

8. **Use Efficient Loops**: Opt for `For Each` or `For` loops instead of looping through a large range. Avoid using unnecessary nested loops.

9. **Close Unneeded Workbooks**: If your code interacts with multiple workbooks, close those that aren't required to reduce memory usage.

10. **Check for Memory Leaks**: Ensure that your code doesn't have memory leaks by releasing objects and variables that are no longer needed.

11. **Use Application Events Sparingly**: If you're using application-level events in your VBA code, make sure they are necessary and are not causing excessive overhead.

12. **Update Excel**: Ensure that you're using an up-to-date version of Excel with all available updates and patches installed.

13. **Consider 64-bit Excel**: If your data is very large, consider using the 64-bit version of Excel, which can handle larger memory allocations.

14. **Profiling**: Use profiling tools to identify bottlenecks in your code and focus on optimizing those areas.

15. **Error Handling**: Implement proper error handling to prevent crashes and unexpected issues that can slow down your program.

By optimizing your code and implementing these best practices, you should be able to improve the performance of your Excel VBA-compiled software.

Google FRP Lock

August 16, 2023 0

How to unlock google lock on android phone after factory reset

Google FRP lock is a security feature that Google have on Android devices with Android OS Version 5.1 (Lollipop) and higher. It is a built-in security feature that protects users device and information, including screen locks and data encryptions. it helps to protect android devices from authorized use. 

This occurs automatically if a device is factory reset through an untrusted way. Normally when you wipe data/factory reset via Recovery Mode 

Not Connected – No Connections are available

August 04, 2023 0

HOW TO FIX “Not Connected – No Connections are available” ON WINDOWS 10/Windows 11



 “Not connected – no connections are available” is a common problem for windows 11 OS when you first upgrade the operating system on your computer or you have more wifi network connected to your computer. In most cases, this error occurs due to outdated drivers, network device being disabled or corrupt DNS cache. So how can we fix this problem? Yes this post will tell you more on about how to fix not connected  - no connections are available

 Well is frustrating when you really wanted to use your PC to do your work over the internet like checking your email or publishing your blog and manage your Facebook page but you realized that you can no longer connect to the internet or your PC can not find any available Wifi. If you are facing such problem, do not worry, continue to read the step - by - step instruction listed below and practically try them out to put your computer wifi back and running.

This step-by-step instruction is a guide for you to manually fix this problem

1.       Open Control Panel, View by Category

2.       Click Network and internet

3.       Click Network and sharing center

4.       Click change adapter settings

5.       Identify your network adapter name

6.       Open device manager

7.       Expend network adapter name, select your network, right click and enable devices

8.       Open CMD

9.       Type “ipconfig /flushdns” (without quotation marks) and hit enter

10.   Type “ipconfig /renew” (without quotation marks) and hit enter

11.   Type “netsh winsock reset” (without quotation marks) and hit enter

12.   Type “exit” (without quotation marks) and hit enter

13.   Open network reset

14.   Click “reset now” and select “yes” to allow network reset

15.   Restart the computer to enable configuration to take effect.

16.   Click trouble shoot problem

17.   Select all network adapter to diagnose and click next

18.   Close and done

Open Control Panel, View by Category

Launch control panel by clicking windows icon below the desktop on the taskbar of your computer or press the windows key on the keyboard and just type “Control Panel” to allow the system to find a best match for your request. When you see Control panel appears on the best match list, select and let it open up Control Panel App.

Once you launch control panel, make sure on the top right hand conner, where it says “view by:”, must have category selected. If you click on the drop down, you’ll have “Category”, “Large icon” and “Small Icon”. select “Category” to have better access to the list.

Click Network and internet

Now select network and internet. This part of the configuration will allow you to check network status and change its settings, set preference for sharing files and computers, configure internet display and connections and other network and internet settings. But we want to go to Network and sharing center

Click Network and sharing center

Click on Network and Sharing center to view the basic network information and setup connections. This section may again allow you to check network status and change its settings, set preference for sharing files, printers and computers. But we want to check the status of our wifi network. That is, we only want to change the adapter setting.

Click change adapter settings

On the left panel list, you’ll find Control Panel Home, Change Adapter Settings, Change Advance Sharing Settings and Media Streaming Options. Select “Change adapter settings” to procced. There you’ll find all network connections for this computer. We want to identify the wifi network adaptor.

Identify your network adapter name

Identify and make note of the network adopter name, because after this step, we will leave and go to Device Manager.

Open device manager

Launch Device Manage by clicking windows icon below the desktop on the taskbar of your computer or press the windows key on the keyboard and just type “Device Manage” to allow the system to find a best match for your request.

Expend network adapter name, Select your network, right click and enable devices

Once Device Manager launched, find “Network Adapter” and expand the list to find your Adaptor Name. Once you locate your device, right click and enable it.

Open CMD

Launch Command Prompt (CMD) by clicking windows icon below the desktop on the taskbar of your computer or press the windows key on the keyboard and just type “CMD” to allow the system to find a best match for your request. Right click on it and run as Administrator

Type “ipconfig /flushdns” (without quotation marks) and hit enter

Once command prompt opens. Type following commands

Type “ipconfig /renew” (without quotation marks) and hit enter

Type “netsh winsock reset” (without quotation marks) and hit enter

Type “exit” (without quotation marks) and hit enter

 

Open network reset

Launch Network Reset by clicking windows icon below the desktop on the taskbar of your computer or press the windows key on the keyboard and just type “Network reset” to allow the system to find a best match for your request. Click to open

Click “reset now” and select “yes” to allow network reset

This will open settings App direct to this specific command. Find where it says “Reset now”. It’s a button on the right, click it and select yes after to allow the windows to flush out all the network adapters and their settings. This will permit your computer to restart, after restart all the network adaptors and their settings will uninstalled and restore to default settings. This is compatible for windows 10 version 1607 or later (NETWORK RESET).

 Restart the computer to enable configuration to take effect.

Click trouble shoot problem

After the restart and your problem persist, right click on the internet icon where you’d check your connectivity, it will give two options. Troubleshoot problems and open network and internet service, I want you to select Troubleshoot problems, this will identify and correct relevant hardware or software fault that cause the disconnections with your network

Select all network adapter to diagnose and click next

You will see it starts to detect problems until it stops on options for you to select and follow the prompt through. Select “All networks" and go next. Once the trouble shooting has completed. You are all done and good to go. Click close and enjoy your work