• <i id='1ztXv'><tr id='1ztXv'><dt id='1ztXv'><q id='1ztXv'><span id='1ztXv'><b id='1ztXv'><form id='1ztXv'><ins id='1ztXv'></ins><ul id='1ztXv'></ul><sub id='1ztXv'></sub></form><legend id='1ztXv'></legend><bdo id='1ztXv'><pre id='1ztXv'><center id='1ztXv'></center></pre></bdo></b><th id='1ztXv'></th></span></q></dt></tr></i><div id='1ztXv'><tfoot id='1ztXv'></tfoot><dl id='1ztXv'><fieldset id='1ztXv'></fieldset></dl></div>

      <bdo id='1ztXv'></bdo><ul id='1ztXv'></ul>

    <small id='1ztXv'></small><noframes id='1ztXv'>

    <tfoot id='1ztXv'></tfoot>
      <legend id='1ztXv'><style id='1ztXv'><dir id='1ztXv'><q id='1ztXv'></q></dir></style></legend>

        行显示为#DELETED

        Rows showing as #DELETED(行显示为#DELETED)

          • <legend id='kKT4h'><style id='kKT4h'><dir id='kKT4h'><q id='kKT4h'></q></dir></style></legend>
              <bdo id='kKT4h'></bdo><ul id='kKT4h'></ul>

                  <small id='kKT4h'></small><noframes id='kKT4h'>

                • <i id='kKT4h'><tr id='kKT4h'><dt id='kKT4h'><q id='kKT4h'><span id='kKT4h'><b id='kKT4h'><form id='kKT4h'><ins id='kKT4h'></ins><ul id='kKT4h'></ul><sub id='kKT4h'></sub></form><legend id='kKT4h'></legend><bdo id='kKT4h'><pre id='kKT4h'><center id='kKT4h'></center></pre></bdo></b><th id='kKT4h'></th></span></q></dt></tr></i><div id='kKT4h'><tfoot id='kKT4h'></tfoot><dl id='kKT4h'><fieldset id='kKT4h'></fieldset></dl></div>
                  <tfoot id='kKT4h'></tfoot>
                    <tbody id='kKT4h'></tbody>
                  本文介绍了行显示为#DELETED的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我在一台计算机上使用 Access 时在表中显示为 #DELETED 的数据行,但它们在 SQL 数据库和其他使用 Access 的计算机上都很好.似乎只有最新的 200 行.Access 2007 版本和 ODBC MSJet 驱动程序看起来相同每台计算机上的最新版本.一个建议是将任何 PK 或 FK 更改为 int,但它们已经是.

                  I have rows of data in a table showing as #DELETED on one computer when using Access but they are fine in both the SQL database and on other computers using Access. It seems to be only the latest 200 rows. The Access 2007 versions and ODBC MSJet drivers look to be the same & latest on each computer. One suggestion was to change any PK or FK's to int's, but they already are.

                  对此有什么解决办法吗?

                  Any ideas for a fix for this?

                  推荐答案

                  当表的主键值超出 MS Access 支持的范围时,通常会发生这种情况,如果您在 SQL Server 中使用BigInt"类型,如果您只是想读取数据,然后只需为表创建一个快照"查询,所有行都将正确显示,因为快照"不需要读取所有索引.

                  This occurs when the tables primary key value, exceeds the range that MS Access supports, usually if you are using the "BigInt" type in SQL Server, if you are only looking to read the data then just create a "snap-shot" query for the table and all rows will display correctly as the "snap-shot" does not need to read all the indexes.

                  如果您需要随时更新这些行中的数据,那么我建议改用 ADO 记录集.

                  If you need to update the data in these rows at any time then I suggest using an ADO recordset instead.

                  这篇关于行显示为#DELETED的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  Building a comma separated list?(建立一个逗号分隔的列表?)
                  Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column(尽管每列都使用了 varchar(MAX),但在导入 CSV 文件时 SQL Server 中出现错误)
                  How can I import an Excel file into SQL Server?(如何将 Excel 文件导入 SQL Server?)
                  Export table to file with column headers (column names) using the bcp utility and SQL Server 2008(使用 bcp 实用程序和 SQL Server 2008 将表导出到带有列标题(列名称)的文件)
                  Concat field value to string in SQL Server(将字段值连接到 SQL Server 中的字符串)
                  SQL Server Bulk insert of CSV file with inconsistent quotes(SQL Server 批量插入带有不一致引号的 CSV 文件)
                          <tbody id='4tMGe'></tbody>
                          <tfoot id='4tMGe'></tfoot>

                            <bdo id='4tMGe'></bdo><ul id='4tMGe'></ul>

                          • <small id='4tMGe'></small><noframes id='4tMGe'>

                            <i id='4tMGe'><tr id='4tMGe'><dt id='4tMGe'><q id='4tMGe'><span id='4tMGe'><b id='4tMGe'><form id='4tMGe'><ins id='4tMGe'></ins><ul id='4tMGe'></ul><sub id='4tMGe'></sub></form><legend id='4tMGe'></legend><bdo id='4tMGe'><pre id='4tMGe'><center id='4tMGe'></center></pre></bdo></b><th id='4tMGe'></th></span></q></dt></tr></i><div id='4tMGe'><tfoot id='4tMGe'></tfoot><dl id='4tMGe'><fieldset id='4tMGe'></fieldset></dl></div>
                            <legend id='4tMGe'><style id='4tMGe'><dir id='4tMGe'><q id='4tMGe'></q></dir></style></legend>