Hello,

I need some help updating Oracle linked tables in Access.

I have linked 2 Oracle tables in Access and I am trying to update data in them (I have the required permission). When I run the query to update the data, I get the following error -

ODBC--call failed.
[Microsoft][ODBC Driver Manager] Invalid argument value (#0)

Could anybody plz help.

Thanks

Can you post the code you are using to update them?

Are you using a DSN, or CurrentProject.Connection? Also, Oracle has its own unique syntax, whereas Access uses ANSI 89 SQL.

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

I get this error when I manually click and run the update query.

I have also coded for the query to run automatically. I'll post the code in a bit.

Thanks