SysChat is a free online computer support community. Ask questions, share resources, contribute knowledge and discuss technology. Join our growing community to access all features. Register Now!

SysChat » Articles » Corruption in Shared Access Database and Recovery


Computer and Technology articles

LinkBack Article Tools

Corruption in Shared Access Database and Recovery

Published by Andrew Watson

Default Corruption in Shared Access Database and Recovery

Database sharing is the most useful and advanced feature of Microsoft Access. This feature has enabled since the Database engine is File based. In order to allow multiple users to share the same file over the network, Jet Database Engine uses a Lock file (.ldb) to synchronize the read write operations of the database.

Unluckily using the Lock file communicates on Windows operating system API calls to control the file synchronization which in turn communicate on file transfer networking protocols. All of the network connections have a bandwidth limit, and any software on your system transferring data on the same network socket can potentially decrease the jet connection speed, when it happens the connection generally disconnects due to the “Time-Out” failure. When it happens, the Access Database is left in a “Suspect” state and generally requires repairing it before allow it to continue.

Most of the times, the network problem leave the Access database in a “Suspect” state and cause corruption. It depends what the users were doing when the network problem occurred. For instance, if the user was performing any large SQL Append query, it is obvious that the database will corrupt. If you increase the network performance by disabling “opportunistic locking, it increase the chances of database corruption in a shared environment.

In all of these situations, you need to repair your Access database in order to use it. You can repair the corrupted database with the help of third party data recovery software that are known as Access Recovery software for repairing MS Access database files.

Access Repair is the application programs that can help you in repairing and restoring the corrupted Access Database in almost all possible cases of corruption. This software works on the header of the corrupted file and repairs and restores it without changing the original contents of the database files. This software is able to repair all the elements and components of Access database.

Stellar Phoenix Access Recovery is robust data recovery software to repair and restore the corrupted Access database files. This software helps you in repairing all the elements of Access database including tables, forms, reports, queries and database relationships. Stellar Phoenix scans for corrupted .mdb (Access database files) files to repair and restore it to a default location or a user specified location on the hard drive. This software can recover the data from all file versions of Microsoft Access including Access 97, 2000, 2002, 2003 and 2007.


Article Tools

Similar Threads
Article Article Starter Category Comments Last Post
OST File Recovery and PST File Recovery Sami Backup and Data Recovery 1 09-07-2007 12:42 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are on

» Ads

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54