“警告:表的元数据中的错误..."在打开数据库 [英] "WARNING: Error in the metadata of the table ..." on opening database

问题描述

连接到某些数据库时，我收到这样的警告消息:

I'm getting a warning message like this when connecting to some databases:

表的元数据中的错误tblCourses:元数据中表的行数为69，但UCanAccess已找到并加载了37条记录.一切正常，但是最好修复数据库.

Error in the metadata of the table tblCourses: table's row count in the metadata is 69 but 37 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database.

我的数据库中的记录未全部检索到.我不知道行计数是从元数据中获得的吗?

The records in my database were not all retrieve. I didn't know row count is gotten from metadata?

知道如何解决此错误的人吗?

Anyone who knows how to solve this bug?

推荐答案

这不是错误. UCanAccess只是报告元数据中的行数与表中的实际行数不匹配.显然，这(至少部分是由于)Access编码中的一些粗心大意，因为重新创建问题的一种方法是在Access本身的数据表视图中的表中插入和删除行.

It's not a bug. UCanAccess is simply reporting that the row count in the metadata does not match the actual number of rows in the table. This is apparently due (at least in part) to some carelessness in the coding of Access, since one way to recreate the issue is to insert and delete rows from a table in Datasheet View in Access itself.

如果您希望警告消失，则只需在Access中打开数据库文件并执行压缩和修复数据库"操作.

If you want the warning to go away then just open the database file in Access and perform a "Compact and Repair Database" operation.

这篇关于“警告:表的元数据中的错误..."在打开数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！