Autonumber Woes

[Kel]

Access 97, Office 97, SR2

In testing my groovey little app, I discovered a not so groovey little problem.. To import my data from a previous Access database, I had to change the autonumber field to regular 'Number'. Now, I am unable to change it back.

I vaugly remember being able to use a query to change these entries from the old to the new, but how can it be done? I've tried an update query, but autonumber fields can't be updated.. Please Help! <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

Thanks!

[PaulK]

This may not be appropriate for your situation but I just had a similar problem (it wouldn't let me add an autonuber field to my already populated table) and solved it by making a copy of the structure of the table, adding the autonum field and then running an append query from the source table to the new table. Of course this was in a db with one table so it may not work for you.

[charlotte]

Drk,

As Paul mentioned, you can always append to an autonumber field, so there isn't really any reason to change the field type in your table. The only reason to change the field type would be if you were going to create ANOTHER autonumber field to generate a new set of keys but you wanted to keep the old numbers for cross referencing. This can be useful where there may, in fact, be identical autonumber keys from two different tables and you need to combine them.