如何修复可能的数据库损坏？ [英] How to fix possible db corruption?

问题描述

我在客户端对他们的访问应用程序做一些快速修复。这是一段时间，我有一个与访问，但我正在迅速恢复。但是，我发现了一个有趣的问题：

I'm at a client doing some quick fixes to their access application. It was a while I had a go with access, but I'm recovering quickly. However, I've discovered an interesting problem:

对于某些报告，我得到记录已删除错误。我检查了报告，似乎有一个表的问题。当打开该表时，我发现一个记录，其中所有列都标记为#deleted。很明显，这一行似乎是罪魁祸首。但是，当我尝试删除该行，没有什么真的发生。如果我重新打开表，该行仍然存在。

For some reports, I get a "Record is deleted" error. I've checked the reports, and it seems like there's a problem with one table. When opening that table, I find a record where all columns are marked "#deleted". So obviously, this row seems to be the culprit. However, when I try to delete that row, nothing really happens. If I re-open the table, the row still exists.

数据库中是否有损坏？ ？我怎样才能删除此记录好

Is there a corruption in the db? How can I remove this record for good?

编辑：这是一个MS2000版本

It's a MS2000-version

解决方案：简单压缩/修复无效。我将数据库转换为2003年的文件格式，这是把戏。我标记了第一个答案建议压缩/修复，因为它指向我的方向正确。谢谢！

Solution: Simply compress/repair did not work. I converted the database to the 2003 file format instead, which did the trick. I've marked the first answer suggesting compress/repair, since it pointed me in the right direction. Thanks!

推荐答案

你试过内置的Access压缩/修复工具？这应该从数据库中刷新删除的记录。

Have you tried the built in Access compact/repair tool? This should flush deleted records from the database.

的确切位置，根据你正在运行Access的版本有所不同，但在Access 2003中它是在工具>数据库实用程序>紧凑和修复数据库。一些早期版本的Access有两个单独的工具 - 一个用于紧凑型，一个用于修复 - 但是他们从类似的位置访问。如果他们是在客户端的版本分开的，你需要同时运行。

The exact location varies according to the version of Access you're running, but on Access 2003 it's under Tools > Database Utilities > Compact and repair database. Some earlier versions of Access had two separate tools - one for compact, one for repair - but they were accessed from a similar location. If they are separate on the version the client has, you need to run both.

这应该是一个非破坏性操作，但它是最好的测试此MDB文件的副本（表示明显的道歉）。

This should be a non-destructive operation, but it would be best to test this on a copy of the MDB file (apologies for stating the obvious).

这篇关于如何修复可能的数据库损坏？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！