Combining Pass Through and Update Queries...

[csunsun]

Hi,

I want to update an Access table from data in an Oracle table using a Pass through query.

When I try to run the query in SQL view it errors out.

Is "UPDATE" not possible in the Pass Through Query?

Thanks!!

 

[dhookom]

A pass-through query will only return a non-updateable recordset from the remote server.
What is your SQL and what do you mean by "it errors out"?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]