Results 1 to 3 of 3

Thread: Autonumber Woes

  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Autonumber Woes

    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!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autonumber Woes

    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.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Autonumber Woes

    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.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •