如何禁用Access 2003中的所有AutoNum [英] How to Disable all AutoNum in Access 2003

问题描述

我有一个Access数据库，该数据库已损坏，无法修复(不要问我如何，它是一个客户端数据库).但是，我们可以使用.NET ODBC这样的代码来访问数据.由于我们拥有数据库的完整副本，因此我们计划将所有数据从损坏的数据转移到新的数据.

I have an Access database that is corrupted beyond all repair (don't ask me how, it's a client database). However, we can, using code like .NET ODBC, access the data. Since we have a clean copy of the database, we are planning to transfert all data from the corrupted to the new one.

我们只有一个问题，那就是数据库包含自动编号和大量链接.传输数据时，我们要确保所有自动编号ID均与以前完全相同.否则，我们只会遇到更多问题.

We only have one problem, it's that the database contains autonums and lots of links. When we transfer the data, we want to make sure all autonum ids are exactly the same as they were before. Othewise, we'll just end up with more problems.

有没有办法做到这一点?

Is there a way to do this ?

谢谢

推荐答案

我相信ACCESS Select into可以使自动增量保持不变.之后，您可以继续在干净的数据库中工作.

I believe ACCESS Select into's will keep the autoincrement unchanged. After that, you can continue working in your clean db.

这篇关于如何禁用Access 2003中的所有AutoNum的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！