Friday, October 3, 2008

"Record set is not updateable” Error in Access

In Microsoft Access, you can bind an Access form to an ADO recordset that is using data from an Oracle or SQL database. If you want to update the form, you must make sure that both requirements met such as The ADO connection that is used by the recordset must use Microsoft OLE DB Provider for Oracle and The ADO recordset must be opened as a client-side cursor. When you try to programmatically edit records in an access table by using an ActiveX Data Objects (ADO) recordset in a Microsoft Office Access database project, you may not be able to edit the records.

There could be many things that cause these behaviors as If the form is based on a query that is not updatable, you will not be able to modify data on the form done with your database or the query or the form is based on a linked table that does not have a primary key or a unique index and This happens when the field you are trying to change comes from a table without a key field joined to another table in the query. It may be possible your database is corrupted or virus affected but we will discuss it later. Let’s work around with above errors.

To fix this error review any table design changes you might have made change key fields, remove key fields, replaced table with one from another db. If it is then change it in original form. You can install new latest Microsoft Data Access Components which fix many errors because sometime it cause due to version issues. You can try compact the database, and if that doesn't help try recreating the query: open it in SQL view; copy and paste the SQL text to Notepad; delete the query; create a new query and paste the SQL back or you can go for this method. First open the database and check the user and group permissions via tools on the menu. Make sure that the objects (Tables) you want to update have the update permission checked. Secondly Ensure the table owner is you or admin and not the person who developed.

If still you are getting this message it points toward database corruption. You should use compact and repair utility but in critically damaged file compact and repair utility doesn’t support. Now you need a good Access Repair utility. You can search lots of repair utility on internet. I know one recover utility which is Stellar Phoenix Access Recovery tools. This access recovery software helps you to repair database file. It fixes errors in recordset and errors that cause database corruption in mdb file. This mdb repair or access repair utility supports every version of Microsoft access as Access 97, 2000, 2002/XP, 2003 and 2007

Thursday, October 2, 2008

Reliable Way to Recover Deleted Files

We are living in a new world equipped with technology and gadgets. Day by day we are looking for more advance technologies. Everyone wants to store your important files and data in secure way. We rely on computers for storing our precious data and documents which is safe and secure for our data storage. The data is stored in files and folders on the hard drive. When we open an application for our daily work and every time we click “save as” that file is written to an area of the hard disk. Each stored file has a "pointer" assigned to it. These pointers are used by the operating system to locate where that piece of data resides on the hard drive.

Sometimes we accidentally delete an important file or folder which contains program files, records, presentation documents and important data for our business productivity. If we use only DEL command from the DOS command prompt our files goes directly into the Recycle Bin and there is a good chance to recover our files by double clicking the recycle bin, your file will be restored back to its original location on the hard drive but incase of using del+shift command or hard drive crash we loss our file for ever. So that file recovery is not possible. It's the same thing that happens when you empty the Recycle Bin or the Trash folder.

The file you deleted occupied space. You erased it, but it's really still there, files don’t get deleted permanently, actually these deleted files are available on you hard drive only your operating system cannot access these file because the address of the file has been deleted from the file system. Now the question arises is there a Way to Recover Deleted Files?

Yes it is possible to recover deleted files and the solution is Data Recovery Software. Stellar Phoenix File Recovery Software can recover your data or files.

File Recovery Software is a quick and effective way to restore accidentally deleted files. It can also recover files that have been emptied from the Recycle Bin, permanently deleted files within Windows using the Shift + Delete, and files that have been deleted from within a Command Prompt. The Advanced file recovery provides a great variety of specialized filters that allow you to find and work closely with specific deleted information and files.

File Recovery is a powerful utility which will recover deleted files, including documents, graphics, digital camera photographs, Zip files, email, music, video and more. It will bring back files emptied from the Recycle Bin, from a formatted disk, lost due to a system crash. File Recovery Software is compatible with Windows XP and works with FAT 12, FAT 16, FAT 32, NTFS and NTFS5 file-systems. It provides hierarchical organization to files, information about those files, and management of space to where those files physically reside on the hard drive. Once you purchase File Recovery Software you can use it over and over again.

Monday, September 29, 2008

Master Boot Record Failure or Partition table Causes Data Loss

In the world of mainframes and microchips everyone that uses a computer always know the value of data stored on the hard drive of a computer. Computer data is one the most precious assets and is a bigger part of our life than ever before.On an early morning you start your computer for your daily work unfortunately you found that your hard disk is not recognized by your OS until it was working quit fine since last night .you only hear the hard disk spinning and the pc fan, but get nothing more. You use your all knoppix and other methods to access your hard disk but all goes in vain.

In windows based operating systems the computer starts with a small program that is executed when a computer boots up. This program called Master Boot Record MBR which is fundamentally utilized to hold information about the structure and function of the disk including the location of saved data. These volumes contain machine codes responsible for the booting process of the computer and layers of separation called partitions. When this section of your pc gets corrupted or damaged you will probably get a reading Error message for the MBR.

It is likely that when your partition is damaged or corrupts due to virus attack, hard disk failure or corrupt partition table caused by the faulty manipulation of the Master Boot Record (MBR). A corrupt partition table will often result in loss of data and the inability to boot from a drive or the loss of access to a certain partition.

In various cases where access to an entire disk or partition is lost, is often caused by damage to Meta structures such as the MBR, Partition Tables or the Boot Sector of an individual partition.

Now the situation arises whether the data can be recovered from the corrupted MBR or partition table damaged?

Yes it can be recovered with help of Data Recovery software which is an ultimate solution to data loss when you experience a drive error. This powerful and easy to use tool will automatically checks and repairs the master boot record, partition table and any windows related error. Partition Recovery Software recover data lost after accidental formats, software corruption and virus problems or from formatted missing partitions supporting NTFS, NTFS5, FAT16, FAT32 file system.

This Software with advanced features recovers storage media including all, IDE, SATA, EIDE disk media and storage media and provides multi storage support to hard disks.

It has an enhanced recovery support to virus affected disk drives. Data Recovery is designed to restore files and folders when emptied recycle bin or content deleted permanently using shift+delete keys. It recovers your key files or directories folders which are lost, formatted or deleted. Corrupted MBR or MR is not the cause of worries, if you have this smart tool.

RAID Recovery Process

You can get much greater capacities, avoid losing data from disk failure, and do all that at reasonable cost using a technology called Redundant Array of Inexpensive Disks (RAID. Servers usually function without manual intervention and they are expected to work almost constantly, therefore, RAID is used. This term defines a computer data storage scheme that divides and also replicates data among varied hard disks. In a RAID, the different physical hard disks are combined into a single logical unit by using a special hardware or software.

The three key RAID concepts are:

  • · Mirroring - that of copying data on to different disks in the array
  • · Striping - the splitting of data in more than one disk, and finally
  • · Error correction - redundant data is stored for error detection if the need arises

RAID systems are designed to work reliably; therefore, they are ideally suited for servers. However, at times, RAID array also fail and data recovery from a (RAID) server is a complicated process.

Data loss usually induces panic. Losing data from a RAID server necessitates an important precaution. The disk array order should not be changed. Even if they are removed from the server, they should be placed back in the same order and the data recovery experts must be contacted.

As RAID system provides the inbuilt data protection, for that businesses are looking for to prevent data loss, most businesses count on it. It protects the computer data and help users in avoiding the downtime that accompanies data loss. Many businesses and individual users bank on it to house their mission vital data like business system data (back office, emails, large databases etc) and financial data. However, as it is the case with all technologies, nothing is fail-safe, including RAID drives.

What happens when there is a main issue with the RAID systems that leads the inaccessible data? Though RAID systems are specially designed to safeguard against data loss, they are at rest susceptible to complete system failures if all the drives face problems at same time. Further problems with RAID may occur when RAID controllers do not recognize the disks in the array or if a disk is detached from a hot swappable disk bay and the new disk is swapped in incorrect order. The main thing is that, like a single hard disk system, RAID system can also face the problems and can lead to data loss. But the main difference is, with the RAID failure, the problem can plainly spoilt the business or can halt work because the data written on RAID array is generally business critical.

Unluckily, after facing the RAID malfunction, several businesses give up the hope that the data is inaccessible and there is no chance of recovery. When the RAID failure occurs, most think that it is the end of line for the data- if RAID is broken then there is no method for data recovery. This is simply wrong and businesses need to understand that there are options to recover data. Data Recovery service provider experts can fix this king of data loss problems.

Data recovery service providers are the companies that provide the recovery of the data that are lost due to hardware malfunction. In the case of RAID systems these recovery services can recover data from failed RAID drives. These companies have specially designed data recovery labs, called Clean Room, to recover the lost data with their expert and high technical staff.

Stellar Information Systems is a leading data recovery service provider company that provides data recovery solution through the world. The company can recover data from failed RAID drives