ODBC Fail error adding record to SQL server table (in MS Access)
Posted on 2014-04-17
I have an Access Linked (To SQL Server) table.
Using VBA I open it as a DAO Recordset, DbOpenDynaset, DBSeeChanges
I add a record (.AddNew, !Fieldx=1, .Update). No issues, no errors. I see it in SQL server.
I attempt to add another record and get ODBC Fail Error.
I tried changing the code to use DoCmd.Execute a query (with DBSeeChanges) that appends the record. Nada....
I tried all sorts of fixes including closing table and relinking it (In the error trap code).
I added a TimeStamp field to the SQL Table. (Although existing records, the field appears to be NULL New record has a value)
Nothing works. Please help!
(This is not simple. I have Expert level experience with Access and good experience with SQL Server.)