'Table or view does not exist' error

Hello all,

I'm using VB6, ADO, and Oracle 8.1.6, ComponentOne TrueDBGrid7 and I'm having a problem updating from a grid source...

I can connect to the database, and run a SQL statement on a table i.e.:

select FIELD1 from TABLE1 where COND1 = 'T'

There is a public synonym on TABLE1. I can write SQL statements to insert, update, delete, select on TABLE1 without qualifying the owner with no problem. However, when I'm using the grid with the above select statement, and get my result set, when I change a value on a row, then click off the row to update I get the oracle error:

'Table or view does not exist.'

We have similar setups with other clients, and there is no problem updating from a grid, so I'm not sure why the grid doesn't know what table to update since the ADO recordset it's displaying data from should be connected to the correct table since it's returning queries just fine. Any help would be appreciated. Received on Thu May 05 2005 - 11:04:46 CDT