SQL丢失数据 [英] SQL Losing Data

问题描述

我们正在使用带有Access 2000 MDB的SQL Server 7作为前端，使用ODBC

链接表。我最近为这个应用程序创建了一组新表，而用户抱怨未保存的数据在转移到新的
记录时丢失了。当有多个用户时似乎就是这种情况。当

是一个使用它的用户时，我们似乎没有这个问题。


我们第一次遇到这个问题从MDB转换回来

结束了多年前的SQL 7后端，但我们在

时没遇到这个问题。这些是第一个全新的几年创建的表格，

我们似乎又遇到了这个问题。


当它处理新的问题时，这是否与SQL 7有关表？关于

怎么做的想法？


谢谢！


Neil

We''re using SQL Server 7 with an Access 2000 MDB as a front end with ODBC
linked tables. I recently created a new set of tables for the app, and users
are complaining that unsaved data is being lost when they move to a new
record. This seems to be the case when there are multiple users. When there
is a single user using it, we don''t seem to have that problem.

It seems that we had this problem when we first converted from an MDB back
end to a SQL 7 back end, years ago, but we haven''t had this problem in a
while. These are the first "entirely new" tables created in several years,
and we seem to be having that problem again.

Is this something with SQL 7 when it''s dealing with new tables? Any ideas on
what to do?

Thanks!

Neil

推荐答案

关于这个问题的另一个注释。如果我进入现有记录，在

字段中键入数据，保存记录（使用Shift + Enter），然后立即在同一字段中键入更多数据

，我收到消息，数据已被更改。另一位

用户编辑了此记录，并在您尝试保存更改之前保存了更改。

您的更改。消息清除后，可以执行输入/保存/输入的步骤，而不会出现任何错误。但是当你第一次转到记录并执行这些步骤时，错误总会出现。


这种情况​​发生在数据库的网络版本上，以及我的

个人副本（使用MSDE），所以我知道这不是一个多用户问题，而是一些

类的故障。看来它可能与下面的消息有关。

丢失数据，所以我在这里发布。


有什么想法吗？


谢谢！


Neil

" Neil Ginsberg" < nr*@nrgconsult.com>在消息中写道

news：ye ***************** @ newsread3.news.pas.earthl ink.net ...

Another note on this issue. If I go into an existing record, type data in a
field, save the record (using Shift+Enter), then immediately type more data
in the same field, I get the message, "The data has been changed. Another
user edited this record and saved the changes before you attempted to save
your changes." Once the message is cleared, the steps of
typing/saving/typing can be performed without any errors. But when you first
go to a record and perform those steps, the error always comes up.

This happens both on the network version of the database, as well as in my
personal copy (using MSDE), so I know it''s not a multi-user issue, but some
kind of a glitch. It seems that it might be related to the below message re.
losing data, so I posted it here.

Any ideas?

Thanks!

Neil
"Neil Ginsberg" <nr*@nrgconsult.com> wrote in message
news:ye*****************@newsread3.news.pas.earthl ink.net...

我们正在使用SQL Server 7和Access 2000 MDB作为前端与ODBC
链接表。我最近为该应用程序创建了一组新的表格，并且
用户抱怨未保存的数据在转移到新记录时会丢失。当有多个用户时似乎就是这种情况。当有一个用户使用它时，我们似乎没有这个问题。

我们第一次从MDB转换回来时似乎遇到了这个问题多年前结束了SQL 7后端，但是我们在
时没遇到过这个问题。这些是第一个全新的几年后创建的表格，
我们似乎又遇到了这个问题。

当它处理新表时，它是否与SQL 7有关？关于该怎么做的任何想法？

谢谢！

Neil

We''re using SQL Server 7 with an Access 2000 MDB as a front end with ODBC
linked tables. I recently created a new set of tables for the app, and
users are complaining that unsaved data is being lost when they move to a
new record. This seems to be the case when there are multiple users. When
there is a single user using it, we don''t seem to have that problem.

It seems that we had this problem when we first converted from an MDB back
end to a SQL 7 back end, years ago, but we haven''t had this problem in a
while. These are the first "entirely new" tables created in several years,
and we seem to be having that problem again.

Is this something with SQL 7 when it''s dealing with new tables? Any ideas
on what to do?

Thanks!

Neil

Neil Ginsberg（nr*@nrgconsult.com）写道：

Neil Ginsberg (nr*@nrgconsult.com) writes:

关于这个问题的另一个注释。如果我进入现有记录，在字段中键入数据
，保存记录（使用Shift + Enter），然后立即在同一字段中键入更多数据，我收到消息，数据已经改变。另一位用户在您尝试保存更改之前编辑了此记录并保存了更改。清除消息后，可以执行键入/保存/键入的步骤，而不会出现任何错误。但是当你第一次进入记录并执行这些步骤时，错误总是会出现。

这在数据库的网络版本以及
我的个人副本（使用MSDE），所以我知道这不是一个多用户问题，
但是某种故障。它似乎可能与下面的消息重新相关。丢失数据，所以我把它发布在这里。

Another note on this issue. If I go into an existing record, type data
in a field, save the record (using Shift+Enter), then immediately type
more data in the same field, I get the message, "The data has been
changed. Another user edited this record and saved the changes before
you attempted to save your changes." Once the message is cleared, the
steps of typing/saving/typing can be performed without any errors. But
when you first go to a record and perform those steps, the error always
comes up.

This happens both on the network version of the database, as well as in
my personal copy (using MSDE), so I know it''s not a multi-user issue,
but some kind of a glitch. It seems that it might be related to the
below message re. losing data, so I posted it here.

这个问题和另一个关于丢失数据的问题，听起来像

问题在应用。由于我不知道Access，我不能真的

确切地说是什么。

-

Erland Sommarskog，SQL Server MVP， es****@sommarskog.se


SQL Server联机丛书SP3 at
http：// www。 microsoft.com/sql/techinf...2000/books.asp

SQL Server没有什么奇怪的新功能

表。此问题更可能是由于使用ODBC或某些

访问特定配置，设置。

记录已更改您发布的错误可能会发生

与几个不同的场景与ODBC链接表

Access。基本上，ODBC将使用时间戳来确定记录是否已更新

。如果没有时间戳

列，它会比较所有列值以查看记录

是否已更新。

某些情况可能导致Access成为困惑的关于

记录是否已更新 - 例如浮动

数据类型。尝试将时间戳列添加到SQL表

并查看是否修复了问题。应该有一些

访问这个主题的知识库文章，你可能需要搜索
。


-Sue


2005年1月12日星期三20:28:22 GMT，Neil Ginsberg

< nr*@nrgconsult.com>写道：

There isn''t anything odd that SQL Server does with new
tables. This issue is more likely due to using ODBC or some
Access specific configuration, setting.
The "record has been changed" error you posted can happen
with a few different scenarios with ODBC linked tables in
Access. Basically, ODBC will use a timestamp to determine if
the record has been updated. If there is no timestamp
column, it compares all column values to see if the record
has been updated.
Some situations can cause Access to become "confused" as to
whether the record has been updated - such as having float
data types. Try adding a timestamp column to the SQL table
and see if the fixes the problem. There should be some
Access knowledge base articles on this subject that you may
want to search for.

-Sue

On Wed, 12 Jan 2005 20:28:22 GMT, "Neil Ginsberg"
<nr*@nrgconsult.com> wrote:

关于这个问题的另一个注释。如果我进入现有记录，在
字段中键入数据，保存记录（使用Shift + Enter），然后立即在同一字段中键入更多数据
，我收到消息，数据已更改。另一位
用户在您尝试保存更改之前编辑了此记录并保存了更改。消息清除后，可以执行打字/保存/输入的步骤而不会出现任何错误。但是当你第一次进入记录并执行这些步骤时，总会出现错误。

这种情况发生在数据库的网络版本以及我的
个人副本（使用MSDE），所以我知道这不是一个多用户问题，而是一些故障。它似乎可能与下面的消息有关。
丢失数据，所以我在这里发布。

任何想法？

谢谢！
Neil

" Neil Ginsberg" < nr*@nrgconsult.com>在消息中写道
新闻：ye ***************** @ newsread3.news.pas.earth link.net ...

Another note on this issue. If I go into an existing record, type data in a
field, save the record (using Shift+Enter), then immediately type more data
in the same field, I get the message, "The data has been changed. Another
user edited this record and saved the changes before you attempted to save
your changes." Once the message is cleared, the steps of
typing/saving/typing can be performed without any errors. But when you first
go to a record and perform those steps, the error always comes up.

This happens both on the network version of the database, as well as in my
personal copy (using MSDE), so I know it''s not a multi-user issue, but some
kind of a glitch. It seems that it might be related to the below message re.
losing data, so I posted it here.

Any ideas?

Thanks!

Neil
"Neil Ginsberg" <nr*@nrgconsult.com> wrote in message
news:ye*****************@newsread3.news.pas.earth link.net...

我们''使用SQL Server 7和Access 2000 MDB作为前端与ODBC
链接表。我最近为该应用程序创建了一组新的表格，并且
用户抱怨未保存的数据在转移到新记录时会丢失。当有多个用户时似乎就是这种情况。当有一个用户使用它时，我们似乎没有这个问题。

我们第一次从MDB转换回来时似乎遇到了这个问题多年前结束了SQL 7后端，但是我们在
时没遇到过这个问题。这些是第一个全新的几年后创建的表格，
我们似乎又遇到了这个问题。

当它处理新表时，它是否与SQL 7有关？关于该怎么做的任何想法？

谢谢！

Neil

We''re using SQL Server 7 with an Access 2000 MDB as a front end with ODBC
linked tables. I recently created a new set of tables for the app, and
users are complaining that unsaved data is being lost when they move to a
new record. This seems to be the case when there are multiple users. When
there is a single user using it, we don''t seem to have that problem.

It seems that we had this problem when we first converted from an MDB back
end to a SQL 7 back end, years ago, but we haven''t had this problem in a
while. These are the first "entirely new" tables created in several years,
and we seem to be having that problem again.

Is this something with SQL 7 when it''s dealing with new tables? Any ideas
on what to do?

Thanks!

Neil

这篇关于SQL丢失数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！