ODBC update - Help please!!

[Luis]

Hi.
I have a db with a odbc link to an oracle table. this link
has Write permissions on the table. If i open the table
and alter data there is no problem, but if i use a form
with vbs code to alter the data i get an error message
saying that "ODBC -- update on a linked table 'TableName'
failed".
This happens on my computer and on the computer of another
colleague of mine, but it doesn't happens on the rest of
the people that uses this DB.
Note: I am the DB Admin.

Why does this happen?

Thanks

 

[John Smith]

Usually, (though for some reason not always!), there is a second message
telling you why it failed. If you are not getting a second message to explain
the reason, all that I can suggest is that you look very carefully at the SQL
that you code is running, using Debug.Print to see exactly what it says often
helps. Check for such things as it violating Primary/Foreign keys; a value
that is of the wrong type, or too large for the column; not supplying a value
to columns that are not Nullable etc.