Access database Damaged Repair method

Access database corruption is mainly divided into the following situations: 1, serious damage, 2, mild damage, 3, some tables are damaged or some of the records of some tables are damaged. The following is a partial description of the solution.

Access database corruption is mainly divided into the following situations: 1, serious damage, 2, mild damage, 3, some tables are damaged or some of the records of some tables are damaged. The following is a partial description of the solution.

1, the use of Access97 can not open the database, the system prompts the "unrecognized database format" or "not the index of the table" and other information, such databases are more serious damage. Serious damage to the database is generally not fixed, only restore the backup, fortunately this situation is relatively rare.

2, if the database damage is not serious, only need to use the Access 97 menu "Repair Database" and "compressed database" can be restored to the database. Because the database is slightly damaged, the general will not cause any problems with the software, so it will not cause people's attention, only when a database or a few tables damaged, it will make the software unstable, so this situation is our most often encountered.

3, how to determine which tables in the database have problems, we first use Access 97 to establish an empty database, using the system provided by the "Introduction database" function, select the target database all tables to introduce, Access 97 when introduced into the problematic table, the system will be prompted with some error messages, Write down the name of the table for later repairs.
Next, use ACCESS97 to open the problematic database and prepare the repair table. The method of repairing a damaged table varies according to the degree of damage to the table, as described in the following ways:

One, the table damage is very serious, performance is unable to open the table, the system prompts "Microsoft Jet cannot find objects", "no read or Write permissions" or "unrecognized" and other information.

Processing method: This kind of table has been badly damaged and can not be repaired in general. If the table is not important or if the contents of the table are usually empty, such as "Common voucher table", "Account share lock table", or "Credential share lock Table", we can introduce the table of other database and then delete the problematic table.

Two, the table has a few lines of content is very confusing or the field labeled "#已删除", but when you want to delete these records, you will receive an error message not to delete.

Approach: Since we don't want to delete these records, we can copy the cousin records to a new table by using SQL statements, and then remove the name of the new table. For example, "Voucher and itemized list Gl_accvouch" in the error record has not been deleted, we can use the following SQL statement to copy good records to Gl_acctemp:

The following are the referenced contents:
SELECT gl_accvouch.* into Gl_acctemp
From Gl_accvouch WHERE {filtered criteria}
Then delete the table Gl_accvouch, and then gl_acctemp the table
Changing the name to Gl_accvouch can solve the problem.

Note: To repair the Access database considerations, first of all, we must do a backup before repairing the database to prevent data loss or corruption; some databases have relation (relationships) to maintain data consistency, but when the database is abnormal, the relation of the related table is lost. After the restoration of the database must be relation again, some software can automatically repair relation, such as Ufida erp8.xx series of products can be a database through the table accinformation [csysid]= ' AA ' and [Project number]= ' 99 ' record, change [set value] and [default value] to ' 8.0a0 ', when re-enter the system, the system will automatically upgrade and rebuild the index.