Friday, June 5, 2009


When the Hard Disk stops functioning properly is referred as Hard Disk failure. This is the most occurring event responsible for data loss which accounts about 44% of total data loss. Hard disk is more prone to damage and corruption as compare to other storage mediums. There may be several reasons for the same:

1. Electronic Failure:  The problems related to controller boards arising due to sudden power spike or electrical surge that makes it undetectable by the operating system. This can happen to any operating system anytime.


2. MECHANICAL FAILURE: These failures happen due to some internal factors of hard disk. When we turn on the system a ticking sound appears and hence can be detected. These are the malfunctioning that can’t be cured by any kind of software but has to be repaired by fetching to a service center.


3. LOGICAL ERRORS:  These are the errors which are not related to physical malfunctioning of hard disk but related to corruption of data or invalid entry to a file system.


When any of the above mentioned incidence happen, our saved data is at the point of loss or simply data loss. At this point of time your hard disk nay stop running or you mat get an error message or you access to the required information gets denied.


There may be several reasons behind this temperature rise in hard disk, invalid data formatting, dust particles entered to the hard disk which could cause a severe damage to your hard disk.



To prevent data from loss there exist several methods by which data can be prevented from loss

1. Giving your system a dust free and dry environment.

2. Use of UPS  to ensure uninterrupted supply of power.

3. Keeping you system in a jerk free environment.



If after adopting above mentioned precautions also data loss happens then there is nothing to be worry about. For even the most critical cases where all data recovery techniques fails data mining comes into action which in independent of all operating systems or file systems. This technique can recover data from completely damaged or erased files too.




This method is completely based on investigating internal factors such as length of the file, structure, format of file etc. Here each sector of the media is searched and investigated and ultimately stored on new file or folders.

One of the main plus point of this technique is that it can search and recover data when its information is not even present on file systems.


So data recovery becomes possible through it easily. Stellar data recovery services follow the same and help you to get out from data loss. All you have to do is to fetch it here to ensure an effective data recovery from even completely damaged hard disks


Compile Error in Converting Macro to VBA

You can create a macro (An action or set of actions that you can use to automate tasks) to perform a specific series of action and you can create a macro group to perform related series of actions. As macro is very useful but at some time you get sick of macros - they're slow, unwieldy and clutter up your database. It's time, then, to convert your crappy old macros to shiny VBA. Fortunately, this conversion couldn't be easier. VBA standards for Visual Basic for Applications and is the language embedded within your Access database.

You can use VBA whenever you do one of the following:

  1. Create a new function.
  2. Create a new subroutine.
  3. Design a global variable.
  4. Execute the RunCode action in a macro.


In conversion of macor to VBA when we run VBA code within ArcMap or ArcCatalog that includes references to Network Analyst objects, you get the following error message when you attempt to run the code.


"The application can not find the wizard or there is a syntax error in the declarations section of a visual basic module”


When you convert a macro to Visual Basic for Applications code using the "Save as Visual Basic Module" command, and the macro contains a RunSQL action that includes a SQL Statement that was copied from a query's SQL View window, you may receive a compile error when you try to compile the module. After you convert macros to Visual Basic for Applications code in a form or report by using the "Convert Macros to Visual Basic" command, you may receive the following error message when you use the form or report.


“The expression you entered as the event property setting produced an error: Compile error”


Basic causes of these errors are missing macros or references due to corruption in database or it may occur when there is a broken Reference in your Access database and you've tried to use one of the built-in Access functions such as Left, Instr, Len, Year, Mid, etc. Second error comes when RunSQL Statement is not being correctly copied to the module during the conversion and is causing the module to fail that also cause error and damaging database. To resolve these problem we can use following method:

  • You can Edit the SQL Statement Action Argument in the macro and remove the space character to the left and right of the equal sign (=).
  • Save, close, and convert the macro again.
  • Edit the code in the converted macro module, and remove the extra line.



Or prevent the error, open a form or report class module in Design view and delete the procedure for the event whenever you replace an event procedure with a macro. One more method to correct the problem, you need to open your Access database then open the Microsoft Visual Basic window and select reference tool menu, when the References window appears, check to see if there are any References checked that start with "MISSING:" If there are any, uncheck these Reference.


If still you get this error that shows your database is critically damaged that causes missing references and modules. In this case compact and repair utility won’t help you. You must go for access repair utility which can repair your database and recover your missing references and modules.


Over Internet, lots of utilities available for repair of access database. One of best tool for access repair is Stellar Phoenix Access Recovery software which provides repair of your mdb and ADP files. It repairs various file versions includes Access 97/2000/2002/2007. Best feature is it recovers missing references and primary key fields, if present. You can check the preview of your repaired database.