Wednesday, July 20, 2011

Use compact and repair utility to repair corrupt MS access database

A hard disk drive with the platters and motor ...Image via Wikipedia -->
If you can't open MS access database files or some of records are get deleted then most probably your access database get corrupted. There are several reasons for database corruption, due to bad network hardware or interruption in MS access operations like write, open or save. Access database have an in-built utility to deal such type of corruption situation. This utility is known as Compact and Repair utility, it repair the corrupted area of access database. It can help you at some extent; if this utility can't help you then you need to use access repair software.What is Compact and Repair Utility
Compact and Repair utility must be used at regular intervals in order to safeguard the information stored in a database. The compact process makes sure you reclaim the unused space, created by object and record deletions, in an Access database file. Compacting a database is necessary, since the objects and records are deleted, then only the space available for new objects, but the size of the database remains the same. Therefore, you must compact a database frequently.

After compaction is finished, the repair process is initiated and that all queries, tables and indexes are repaired.
Note following points before running this utility:-

Make sure you have at least twice the size of the database space available hard disk space
Be sure to set unique permissions both Open / Run and open the Access database
If the database is in a multi-user environment, make sure that any user has open
Make sure the Access database is not read-only attribute or not stored in a read-only shared network
Steps for repairing corrupt database:-

1.Make a backup of the corrupted database.
2. Make sure to delete the LDB file after you close the MDB file related
Compact and Repair Database.
3. Go to Tools> Database Utilities, and click.
4. Choose the file to compact the database to compact, and click Compact.
5. Enter a new name in the Compact Database, and click Save.

If above method couldn't able to fix your problem then you need to use third party access recovery software to repair corrupt database.
READ MORE - Use compact and repair utility to repair corrupt MS access database

Thursday, July 14, 2011

How to Fix QuickBooks Errors While Connecting to Access Database

Linking with access databases is a very easy process but it become difficult at some point of time while QuickBooks database get corrupted or connectivity is not properly done. QuickBooks database will not open properly in both situations. In both cases QuickBooks database will become inaccessible for the user and in worse case user may face data loss situation. If you have backup of QuickBooks data then you can avoid data loss situation. Otherwise you need to use QuickBooks recovery software to get back your data.

You can't run any query on database table to access data from QuickBooks database and not able to see information in the QuickBooks table, if access database is not properly linked with access database.

Here are some sample messages:

“QuickBooks has detected a potential problem in your data file. Please restart QuickBooks and open this company file. From the Windows menu, choose Close All. Then, from the File menu, choose Utilities, and then choose Verify Data. C = 43.”
This message will pop up every time when you run QuickBooks client.

You will get other message when you try to verify .QBW files.

“Problem, A data problem prevents QuickBooks from continuing.

Solution, rebuild your data now. Close all windows and choose Utilities and then Rebuild Data from the File menu. While rebuilding, you need to create backup of company file of QuickBooks database and it gives the same C=43 error while backing up the data.”

The above message is asking to restart QuickBooks. Follow the instruction which is listed in the message to solve your problem but most of the time user not able to fix above errors.

QuickBooks database corruption is main reason miscellaneous behavior of QuickBooks. Users have only one option to fix these errors is to try QuickBooks file repair tool.
READ MORE - How to Fix QuickBooks Errors While Connecting to Access Database
Related Posts Plugin for WordPress, Blogger...