Runtime error '-2147217887(80040e21)
Runtime error '-2147217887(80040e21)': - The changes you requested tot the table were not successful because they would create duplicate values in the index,primary key or relationship in visual basic
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ex:Table Employee have 2 field (Employeecode,EmployeeName
every employee should have his own employeecode.
-Jason = EMP1000
-Jacky = EMP1001
-JACK = EMP1002
database designer will define/create primary key to prevent duplicate data exist in table employee.primary key will define when create table.
every employee should have his own employeecode.
-Jason = EMP1000
-Jacky = EMP1001
-JACK = EMP1002
database designer will define/create primary key to prevent duplicate data exist in table employee.primary key will define when create table.
Cut from MSDN library:
primary key
A column or combination of columns that uniquely identifies a row in a table. It cannot allow null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.
primary key
A column or combination of columns that uniquely identifies a row in a table. It cannot allow null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.
any more question ?
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- answered by MYLim
Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
ayufans
Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
- answered by MYLim
Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
ayufans
Cleanup Volunteer
PRIMARY KEY MEANS : record should be appear one time.(unique).