Hi,
I'm trying to write a query that updates a table that I'm accessing via a database link. I tried writing it as a SQL Pass Through query but MS ACCESS gives an error that says "may not perform insert/update/delete operation inside a READ ONLY transaction".
My query looks something like this:
update mytable@testdblink
set in_date = sysdate
where in_date is null
I'm using a database link to access the table I need to update because I want to avoid giving out a database user account to the user which is needed if I were to use MS-ACCESS linking method to the table.
Please advise how may I write an update query in MS-ACCESS on a table that is using a database link.
Thanks,
MLZ
I'm trying to write a query that updates a table that I'm accessing via a database link. I tried writing it as a SQL Pass Through query but MS ACCESS gives an error that says "may not perform insert/update/delete operation inside a READ ONLY transaction".
My query looks something like this:
update mytable@testdblink
set in_date = sysdate
where in_date is null
I'm using a database link to access the table I need to update because I want to avoid giving out a database user account to the user which is needed if I were to use MS-ACCESS linking method to the table.
Please advise how may I write an update query in MS-ACCESS on a table that is using a database link.
Thanks,
MLZ
