取回已删除的记录 [英] Getting back a deleted record

问题描述

意外删除了一条记录。无论如何要取回它？


如果没有，我知道ID号 - 这是一个自动编号字段。因为

来自其他表的相关数据，我是否可以创建一个新的

记录并将其ID号作为已删除记录的ID号？


谢谢！


magmike

Accidentally deleted a record. Anyway to get it back?

If not, I know the ID number - which is an autonumber field. Because
of the related data from other tables, would I be able to create a new
record and make its ID number, that of the deleted record?

Thanks!

magmike

推荐答案

周五，2007年10月12日14:34:26 -0000，magmike< ma ****** @ yahoo.com>

写道：


如果你没有用db做任何其他事情，数据恢复服务

仍然可以为你取回它。当然你也可以从昨晚的备份中恢复它

。


听起来你违反了数据库设计的规则＃1，并没有在表格关系中选择了
参照完整性强制执行。

这样可以防止意外删除。修复它！


是的，您可以创建一个追加查询并指定您的ID

字段的值。


-Tom。

On Fri, 12 Oct 2007 14:34:26 -0000, magmike <ma******@yahoo.com>
wrote:

If you haven''t done anything else with the db, a data recovery service
may still be able to get it back for you. Of course you can recover it
from last night''s backup as well.

Sounds like you violated rule #1 of database design, and did not have
referential integrity enforcement selected in the table relationships.
That would have prevented the accidental delete. Fix that!

Yes, you can create an append query and specify the value of your ID
field.

-Tom.

>意外删除了一条记录。无论如何要取回它？

如果没有，我知道ID号 - 这是一个自动编号字段。因为来自其他表格的相关数据，我是否能够创建新的
记录并制作其ID号码，删除记录的ID号码？

谢谢！

magmike

>Accidentally deleted a record. Anyway to get it back?

If not, I know the ID number - which is an autonumber field. Because
of the related data from other tables, would I be able to create a new
record and make its ID number, that of the deleted record?

Thanks!

magmike

得到了一个用于更改ID的附加查询示例＃？


如果我有参考完整性设置（我需要研究那个），

当我选择删除记录时会发生什么？


mike


10月12日上午10：01，Tom van Stiphout< no.spam.tom7 ... @ cox.netwrote：

got an example of the append query for changing the ID #?

If I had referential integrity setup (i''ll need to research that),
what would have happened when I selected Delete Record?

mike

On Oct 12, 10:01 am, Tom van Stiphout <[e-mail]:

周五，2007年10月12日14:34:26 -0000，magmike< magmi ... @ yahoo.com>

写道：


如果你没有对数据库做任何其他事情，数据恢复服务

仍然可以为你取回它。当然你也可以从昨晚的备份中恢复它

。


听起来你违反了数据库设计的规则＃1，并没有在表格关系中选择了
参照完整性强制执行。

这样可以防止意外删除。修复它！


是的，您可以创建一个追加查询并指定您的ID

字段的值。


-Tom。

On Fri, 12 Oct 2007 14:34:26 -0000, magmike <[e-mail]>
wrote:

If you haven''t done anything else with the db, a data recovery service
may still be able to get it back for you. Of course you can recover it
from last night''s backup as well.

Sounds like you violated rule #1 of database design, and did not have
referential integrity enforcement selected in the table relationships.
That would have prevented the accidental delete. Fix that!

Yes, you can create an append query and specify the value of your ID
field.

-Tom.

意外删除了一条记录。无论如何要回来？

Accidentally deleted a record. Anyway to get it back?

如果没有，我知道ID号 - 这是一个自动编号字段。因为

来自其他表的相关数据，我是否可以创建新的

记录并制作其ID号，即已删除记录的ID号？

If not, I know the ID number - which is an autonumber field. Because
of the related data from other tables, would I be able to create a new
record and make its ID number, that of the deleted record?

谢谢！

Thanks!

magmike-隐藏引用文字 -

magmike- Hide quoted text -

- 显示引用文字 -

- Show quoted text -

有一个用于更改ID的附加查询示例＃？

got an example of the append query for changing the ID #?

10月12日星期五2007 15:55:24 -0000，magmike< ma ****** @ yahoo.com>

写道：


INSERT INTO SomeTable（ ID，SomeOtherField）

SELECT [Give ID：] AS Expr1，[Give SomeOtherField：] AS Expr2;


它会说哟！不能这样做。

其他表格中有相关记录。

只需亲自试试。


-Tom。

On Fri, 12 Oct 2007 15:55:24 -0000, magmike <ma******@yahoo.com>
wrote:

INSERT INTO SomeTable ( ID, SomeOtherField )
SELECT [Give ID:] AS Expr1, [Give SomeOtherField:] AS Expr2;

It would have said "Yo! Can''t do that. There are related records in
other tables."
Just try it for yourself.

-Tom.

>得到了一个用于更改ID的附加查询的示例＃？

如果我有参照完整性设置（我需要研究）当我选择删除记录时会发生什么？

10月12日上午10：01，Tom van Stiphout< no。 spam.tom7 ... @ cox.netwrote：

>got an example of the append query for changing the ID #?

If I had referential integrity setup (i''ll need to research that),
what would have happened when I selected Delete Record?

mike

On Oct 12, 10:01 am, Tom van Stiphout <[e-mail]:

>周五，2007年10月12日14:34:26 -0000，magmike< magmi ... @ yahoo.com>
写道：

如果您没有对数据库进行任何其他操作，数据恢复服务
可能仍然可以为您取回。当然你也可以从昨晚的备份中恢复它。

听起来你违反了数据库设计的规则＃1，并且没有参考完整性执行在表关系中选择。
这可以防止意外删除。修复它！

是的，你可以创建一个追加查询并指定你的ID
字段的值。

-Tom。

>On Fri, 12 Oct 2007 14:34:26 -0000, magmike <[e-mail]>
wrote:

If you haven''t done anything else with the db, a data recovery service
may still be able to get it back for you. Of course you can recover it
from last night''s backup as well.

Sounds like you violated rule #1 of database design, and did not have
referential integrity enforcement selected in the table relationships.
That would have prevented the accidental delete. Fix that!

Yes, you can create an append query and specify the value of your ID
field.

-Tom.

>意外删除了一条记录。无论如何要回来？

>Accidentally deleted a record. Anyway to get it back?

>如果没有，我知道ID号 - 这是一个自动编号字段。因为来自其他表格的相关数据，我是否能够创建新的
记录并制作其ID号码，删除记录的ID号码？

>If not, I know the ID number - which is an autonumber field. Because
of the related data from other tables, would I be able to create a new
record and make its ID number, that of the deleted record?

>谢谢！

>Thanks!

> magmike-隐藏引用的文字 -

>magmike- Hide quoted text -

- 显示引用的文字 -

- Show quoted text -

有一个用于更改ID＃的追加查询的示例？

got an example of the append query for changing the ID #?

这篇关于取回已删除的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！