Forum Discussion
Refresh Data and Relationship Error (Duplicates)
OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.
Load was cancelled by an error in loading a previous table.
OLE DB or ODBC error: Object reference not set to an instance of an object..
Column 'Week #' in Table 'Gourley_Lynch' contains a duplicate value '35' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
2 Replies
jrfa225 , Check if there any duplicate value coming on the one side of the table in 1-M realtion.
Also refer
Hi jrfa225 ,
First delete the table relationship, then refresh the data, and finally recreate the table relationship.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
