I have an append query that takes data from text boxes located on a form, and then appends it to a linked Oracle table. If the user enters more than ~100 characters, Access gives the Invalid Argument error.
This post explains a possible solution - hardcoding the query instead of calling it:
However, when I do that, I now get an error that says this, so clearly that solution doesn't work:
ODBC--insert on a linked table "TABLE_NAME" failed.
[Oracle][ODBC]No data at execution values pending. (#0)
Please help, I'm running out of ideas and I have to get this resolved today...:(