Insert into Teradata table via MS Access ODBC occasionally fails
I'm creating a front-end for some Teradata user maintenance tables in MS Access. I've started having problems in occasionally not being able to insert or update records in these tables. I've been able to create the tables and then insert or update, but in subsequent sessions have not been able to do so. In another instance a colleague created tables, I was able to make entries. She had to drop the tables and re-create them. After re-linking to the new tables I was not able to insert/ update. I'm using the same ODBC connection setting and process. I've had lots of ODBC problems before, but I'm stumped on this one.