How do I insert into an autonumber field, similar to Identity Ins.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ram - 12 Jan 2005 21:55 GMT

I would like to know if it is possible to import data into an autonumber
field and maintain the current data in the field.

Reply to this Message

Lynn Trapp - 12 Jan 2005 23:03 GMT

You can insert a new value into an autonumber field. You can update data in
other fields that have an autonumber field in the record. Is this what you
are asking for?

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdeisgns.com/Security.htm

>I would like to know if it is possible to import data into an autonumber
> field and maintain the current data in the field.

Reply to this Message

John Vinson - 12 Jan 2005 23:47 GMT

>I would like to know if it is possible to import data into an autonumber
>field and maintain the current data in the field.

An Append query, appending a Long Integer value into an Autonumber
field, is about the only way to do this.

As a rule, it should NEVER be necessary to do so. Autonumbers will
always have gaps; if gaps aren't acceptable - don't use Autonumbers.

John W. Vinson[MVP]

Reply to this Message