Tables aren't indexed

[David]

I am using Access through and ODBC connection to a Cache database on one of
our servers at work. I can't change anything about the global tables
provided by the company and i need to query off of them. The problem is
that these tables are very large and are not indexed in any way. is there
another way to write a query around that problem so it doesn't take all
night to run?

 

[Rick Brandt]

I am using Access through and ODBC connection to a Cache database on one
of our servers at work. I can't change anything about the global tables
provided by the company and i need to query off of them. The problem is
that these tables are very large and are not indexed in any way. is
there another way to write a query around that problem so it doesn't
take all night to run?

If you are really writing the best structured query for the task at hand
and that takes a long time because there are no indexes then no, there is
not much you can do.

Are you writing a pass-through query to the database server or are you
querying against a link? The former could be a lot faster (depending
again on the query).