ODBC with Oracle

[asearle]

Hi Everyone,



I have a number of ODBC passthrough queries which collect data from an Oracle database. This all works fine.

I also have some VBA code which can generate some of these queries 'on the fly' (e.g. passing filter parameters). This also works fine when I avoid using table synonyms.

However, when I programmatically generate a query and try to use a table synonym such as SELECT * FROM T_LOG LOG MSAccess adds the word "AS" and produces the following: SELECT ' FROM T_LOG AS LOG ... which falls over because Oracle does recognise the "AS". If I then manually remove the "AS", the query works fine.

This is a stupid problem which is driving me round the bend so my question is how to stop MS-Access poking its nose in and adding those "AS" entries?

I really hope somone can help me.

Regards,
Alan Searle

Cologne, Germany

[June7]

T_LOG LOG is a table name? Names with spaces, special characters, punctuation (underscore is exception) need to be enclosed in []. Also names that are reserved words (line Date). This is the case for tables, queries, reports, controls, fields. I have never seen Access throw in the 'AS' and am surprised the query will even run after you remove it.