Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

ShabanaHafiz (Programmer) (OP)
20 Aug 07 1:23
I am using Microsoft Office Access 2003.

I have two copies of the same database. These are mde files. Two offices have entered data in these files. I have to merge this data in a single mde file.

I thought to copy table from db2.mde and paste it in db1.mde with Paste Option as Append Data to Existing Table. The problem is that some tables have AutoNumber fields as Primary Key. When I try to append data to these tables, I get the error:

Records were lost due to key violations.

We have received database from another organization and we cannot make any design change. However numbering sequence generated by AutoNumber is immaterial.

Helpful Member!  Remou (TechnicalUser)
20 Aug 07 3:23
The best thing is an Append query that does not include the autonumber fields.

You can also paste by choosing columns, rather than rows to paste, do not select the autonumber field. Hide the autonumber column for the table you wish to paste into before choosing paste append.

Finally, you can change the autonumber fields field type to 'Number', or you can delete them.

All these methods mean that you will lose the relevance of, at the very least, a chunk of autonumbers.
ShabanaHafiz (Programmer) (OP)
21 Aug 07 1:45
Thanks Remou.

Append query helped a lot in merging control table values. But we had to re-enter details of smaller database again because re-arrangement of autonumbers disturbed the description of identifiers.

In any case, it reduced the manual work.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close