Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    Crediton, Devon, England
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Append Conflict (97) (SR-1)

    I would like to append records from one table to another (in another database). The tables have identical structure, say field1 and RecID, where RecID is a (default, incrementing) autonumber field. This autonumber field is the primary key for both tables. Experiments appear to show that Access can't handle this; if you leave the RecID fields as the tables' primary keys, it refuses to allow the append, and if you remove the primary key status you can get non-unique RecIDs. Is there, please, some way to append one set of records to the other and still retain a unique key for each record in the result? (I don't care what the values are, it doesn't have to be a contiguous series, and I don't need to view it. It just needs to be unique!!)

    Thanks for any guidance. - Mike -

  2. #2
    New Lounger
    Join Date
    Nov 2001
    Location
    Crediton, Devon, England
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Append Conflict (97) (SR-1)

    Immediately after posting this it dawned on me that the solution was to append all the fields EXCEPT the autonumber RecID primary index. Everyone is happy. Cheers. - Mike -

Posting Permissions

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