Updating linked oracle tables

[srtedg]

I'm trying to update a linked oracle table via access.

I am getting ORA-01456 "May not perform inser/delete/update operation inside a READ ONLY transaction".

I use the same ODBC connection to connect with toad and I have no problems.

Any ideas?

 

[vbajock]

Can you post the SQL you are trying to execute?

 

[srtedg]

Here it is,

DoCmd.RunSQL ("INSERT INTO REPLICON_FTBE ( FTBE, DATERANGE ) VALUES (" & rs(0) & ", #" & dateStartDate & "#)&quot

I also get the same error if I try to edit the table itself.

 

[vbajock]

If you can't type it into the table either, you've got database permission problems or your ODBC setup is read only on the particular machine your using. Can you edit other Oracle tables ? If they have all become readonly, I would suspect someone reran the ODBC install and messed it up. Have you tried it on another machine?

 

[srtedg]

The read only box isn't selected for the ODBC driver.. checked that first, and about 1,000,000 times since.

I can connect with toad and edit the database..