Thread: ODBC Error
View Single Post
  #5   Report Post  
Dkline
 
Posts: n/a
Default

The version in question is Office 2000. All of the underlying tables are
linked. The Access links are to either one of two Access databases. There
are five links spread over three Excel files.


"Jamie Collins" wrote in message
oups.com...

Dkline wrote:
The query (although a qurey of queries) is not that complicated or

large.

Ah, gotta love that MS Access terminology <g. A 'Query' is usually a
VIEW, sometimes a PROCEDURE but often something non-standard e.g. a
'pass through' link to an ODBC data source.

If your 'queries' are not complicated, then they are probably VIEWs
e.g. to hide the complexity of a JOIN between tables in the database.
Is this correct, or have you something more complicated e.g. 'linked
tables'? Which version of Jet/MS Access are you using?

Jamie.

--