Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AutoNumber (Win ME/Access 97)

    I want to archive data from a file with an autonumber field. Will this field cause conflicts in the history table to which the data is being appended? The field is defined as AutoNum in both tables. I could use a number data type in the history table if the autonum field is troublesome, I guess. Advice and comments?

    Thank you.

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

    Re: AutoNumber (Win ME/Access 97)

    Your history table should NOT have an autonumber in it. You can append values to autonumber fields, but you'll save yourself some grief by using a Long in the history table.
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AutoNumber (Win ME/Access 97)

    Thank you. Although the examples which I set up seemed to work OK, I just had a feeling that it wasn't the best thing to do. I have changed the AutoNum field in the history table to Long Int, still using the same name as in the source table.

Posting Permissions

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