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

Autonumbers AGAIN!

P: 1
Hi Gurus,

Please accept my niave understanding of Access, as i am haplessly lost and don't understand as to why the automation of autonumbers is trying to create new numbers even though i have specifed the numbers to be unique.
I get the follwoing error:

" The changes you requested to the table were not successful because they would creat duplicate values in the index, primary key or relationship.2

Again i would very much appreciate if you could help out?
Jun 11 '07 #1
Share this Question
Share on Google+
2 Replies


theaybaras
P: 52

Again i would very much appreciate if you could help out?
Can you give us a little more information specific to your situation?
That error message occurs when the value in your primary key field is the same as one already existing in the table. If you are specifying a unique value this shouldn't be an issue. If you can provide more information about your form and table structure(s), we may be able to help you track down the problem.

thanks

theAybaras
Jun 11 '07 #2

NeoPa
Expert Mod 15k+
P: 31,186
Hi Gurus,

Please accept my niave understanding of Access, as i am haplessly lost and don't understand as to why the automation of autonumbers is trying to create new numbers even though i have specifed the numbers to be unique.
I get the follwoing error:

" The changes you requested to the table were not successful because they would creat duplicate values in the index, primary key or relationship.2

Again i would very much appreciate if you could help out?
I suspect you're trying to put your own value into an AutoNumber field. It doesn't work that way. ACCESS assigns the AutoNumber values. If you want to be able to put your own numbers in there and keep it unique, just set it to a Number field and make it an index which is unique.
Jun 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.