Several practical ways to fix Access databases

To repair an Access database, we typically use Access 97 in Microsoft Office 97 to repair and defragment the database. Access databases are corrupted in several cases: 1, severe damage, 2, mild damage, 3, some tables are damaged, or some records in 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:

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.

Fix the considerations for an Access database, first of all, we must do a backup before repairing the database to prevent data loss or corruption; there are relation (relationships) in some databases that maintain consistency of data, 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.