I am attempting to use Access to paste a number of records into a DB2 table linked by ODBC. I'm attaching an image of the error message I am getting when I try to add a test record. What does this table not like about my data?
Competent Performer
Windows 7 64bit 
Access 2010 64bit
I am attempting to use Access to paste a number of records into a DB2 table linked by ODBC. I'm attaching an image of the error message I am getting when I try to add a test record. What does this table not like about my data?
Competent Performer
Windows 10 Access 2013 32bit
You need to identify what constraints exist on the table, and then look at your SQL statement to see what you are not providing.
Competent Performer
Windows 7 64bit Access 2010 64bit
Is there an SQL statement I can write in i Navigator that will tell me what the contraints are? I've looked at the table in Access and don't see any requirements that I'm not fulfilling with records. I'm also doing this by pasting the data from Excel and not writing an SQL statement to do it.
Competent Performer
Windows 10 Access 2013 32bit
Given the error message it looks like you are linked to the table via ODBC and the source is IBM DB2. You will have to go to the source to identify the field constraints.
Insert/update values into linked table (linked from sql server via odbc connection)
Posting Permissions
Reply With Quote