Archive for the ‘Database Recovery’ Category
Recovering data from a damaged database table or a corrupted database table in Access 2000, 2002 or 2003
Sometimes when you try to run a query, a report, or a form, update records or scroll through data in a damaged Access database table, you receive following error messages:
“Jet has stopped the process because you and another user attempted to change the same data at the same time”
When you use Jetcomp.exe to compact a database, you may receive the following error message:
“Records can’t be read, no read permissions on MyDatabase”
Analyzing causes and resolutions for Access Database Corruption
Microsoft Access database is useful utility, with which user is able to maintain databases for continuous management of information. Access database corruption can land you up in trouble. Mostly, the fatal system errors like an invalid page fault, an application exception error or a STOP error, force the Windows based applications such as Microsoft Access to fail and it just stops responding. Adding to worst, these errors even cause the operating system to stop responding.
Dealing with Access errors occurred while record updation
Records are updated in tables or forms of .mdb files daily. There are various ways of updating the records in an Access database. Some methods are simple, convenient and effortless while others may need some coding. For example, updating the record based on a query may not always turn out to be correct.
How to prevent Access Database Corruptions?
While working with MS Access databases, nothing is more frustrating than the corruption of mdb database files storing all your important information. In such a situation, only powerful and competent Access recovery tools can repair the corrupted database and recover all its components in a convenient manner. A more practical approach to the situation is to prevent the corruption. Below are some of the useful strategies that can be used to prevent your database from becoming corrupted.
Dealing with MS Access Database Corruption after executing or modifying a Query
Microsoft’s Access Database is very popular and effective database, used in every field whether it’s banking, human resources, manufacturing, payroll systems, reservation center, airlines etc. The basis of Access Database is queries. Queries in MS Access lets you do whole lot of things. You can preview, combine, and modify data stored in database tables as per your requirements, using these queries.
Error: SQL Server – Error starting esri_sde service -93 DBMS error code: 18456
Whenever there is inconsistency with the password, the following error message is logged in the SDE error log after trying to start the ArcSDE service:
IDBInitialize::Initialize Failed
init_DB DB_instance_open_as_dba: -93
DBMS error code: 18456
Microsoft OLE DB Provider for SQL Server: Login failed for user ’sde’

