Autoincrement Id Shows Lesser Access Table Records

Share:    

An access database might get corrupt due to power interruption while the database is open or for several other reasons

. You can deduce this by errors it prompts, abrupt behavior, and issues while updating the database. Regardless of the cause, a corrupted database can be easily salvaged using commercial access database repair applications, in case no valid backup is available. However, there are methods too.

To illustrate, consider you use an Access Database with a table containing 'x' number of records. When you view the Autoincrement Id for a new record, it shows the table with lesser records and a difference of 'y' records than the original. Trying to update the table gives an error message, as below:

Primary index is not unique

You use DbEngine.CompactDatabase code to try compacting the database, but it deletes the last 'y' records without displaying any error message.
Share:    

Cause

Access database is corrupt. Using DbEngine.CompactDatabase for a corrupted database might cause data loss.

Solution

It is suggested to backup the database before applying any repair solution. To repair the corrupted Access database, you should use 'Compact and Repair' utility as follows:

Access 2007:

Close the database

Start Microsoft Access and click 'Microsoft Office Button'

Point to 'Manage' and click 'Compact and Repair Database' under 'Manage this database' section

Browse to the affected database in 'Database to Compact From' dialog box and double-click it to start the repair process

Access 2003 and earlier:

Close the database

Launch the application and click 'Tools' menu

Point to 'Database Utilities' and click 'Compact and Repair Database'

Browse to the corrupted database in Database to Compact From' dialog box

Click 'Compact' and proceed as per the instructions

Open the database after the repair process completes. If it still shows corruption symptoms, you need to apply third-party tools for repairing damaged Access databases.

access repair software are powerful utilities, which are exclusively designed for fixing corruption errors with MDB files. These applications come integrated with interactive interface and allow for easy Access Database Repair in any instance of database corruption.

by: colindolly

POST COMMENT

Bankruptcy Auto Loan: Knock At The Right Doors Autopartslocator: Best For All Used Parts Of Vehicles Auto Emergency Kit Why You Should Follow These Rules When Using Autoresponders Autopartslocator-the Best Online Store To Acquire Genuine Suzuki Used Parts. Autopartslocator- The Ultimate Place To Find Cheapest Salvage Parts For Auto Parts Wholesale Offers Better Services, More Exciting Best Deals, More Auto Car Parts For The I Auto Loans Fast Approval - Get The Car As Soon As Possible If You Wanted Autoresponders & Online Business Go Hand In Hand Restyling Auto & Upgrading Customization Your Car Made Easy At Auto Parts Corner Can Help Looking For Genuine Nissan Used Parts? Visit The Autopartslocator And Find The Best Deal On Them. Buy Mitsubishi Used Parts With Complete Satisfaction From Autopartslocator High Quality Auto Parts For Chevy Parts, Toyota, Nissan Parts, Honda Parts, And Jeep Parts Users! No