MS Access"id"不是有效的索引 [英] MS Access "id" is not a valid index

问题描述

当我尝试打开访问数据库时，出现一条错误消息，提示id不是有效的索引.

When I try to open my access database I get an error that says id is not a valid index.

我根本没有更改数据库的布局.该数据库位于网站上，并且可以毫无问题地进行编辑和添加.

I did not change the layout of the database at all. The database is live on a website and it is able to edit and add to it without a problem.

我该怎么办才能打开数据库?

What can I do to open the database?

推荐答案

我遇到了同样的问题，并在Internet上发现了这个问题.可能对你有帮助 您可以按照以下方法进行操作

I had the same issue and found this on Internet. It may help you You can do following approach

起初，我尝试压缩并修复"数据库.那没用.接下来，我尝试创建一个新数据库并从损坏的数据库中导入表，表格，报告和查询.当我尝试导入时，我只收到一堆"ID不是该表中的索引"消息，仅此而已.导入将在此时停止.

At first, I tried to "Compact and Repair" the database. That didn’t work. Next, I tried creating a new database and importing the tables, forms, reports and queries from the corrupted database. When I tried the import, I just got a bunch of "ID is not an index in this table" messages and nothing more. The import would stop at this point.

最终可行的方法是打开损坏的数据库，然后将每个对象从损坏的数据库手动导出到全新的数据库.我可以使用功能区栏中的导出工具并选择访问"作为导出选项来执行此操作.我确实必须先创建一个新的空白数据库.数据库以将所有数据导出到该数据库.

What eventually worked was to open the corrupted database and manually export each object from the corrupted database to a brand new database. I was able to do this with the export tools in the ribbon bar and by selecting "Access" as my export option. I did have to create the new, blank database first; the database to export all of the data to.

不幸的是，我一次只能导出一个对象.所以花了一段时间.

Unfortunately, I could only export one object at a time. So it took a while to do;

答案来源:" http://www.lmhproductions.com/237/microsoft-access-id-is-not-an-index-in-this-table/"

谢谢

这篇关于MS Access"id"不是有效的索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！