By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,867 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Autonumber failure

P: n/a
Ted
I have a table with Autonumber as the primary key. I have Paste Appended a
thousand or so records. Now adding a new record creates a duplicate Primary
Key number?

I'm using Access 2002 - has anyone else seen this?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can always override an autonumber in a table update in Access by
providing a number for the autonumber field, maybe this is happening in
one of your appends?

DM Unseen.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.