query against remote server will not run

  • Thread starter Thread starter jackie
  • Start date Start date
J

jackie

Hi,
I am linking to a remote oracle database through access. I have a table of
names that I need to run against this remote table. However, when I try to do
this, I get no output. It just runs and runs.
I have no rights to alter the remote database in any way. I don't think a
pass-through query will work because of this. (Not sure about that). I am
using an inner join. On the left I have my small table of records (about
100). on the right I have the orcle table that I am linked to (about one
million records).
If I had rights to alter the remote database, what could I do to make the
data run faster. And since I don't have rights, am I doing something wrong.
Thank you.
 
If you are joining an Access table with an Oracle table, you can't use a
pass-through query. Provide us with your SQL statement. Maybe someone who
knows something about Oracle can help.
 
Back
Top