Query Oracle Dual via Access Link Table?

[Luting]

Hi everyone,

I am working on a project using Access as the frontend of a Oracle
database. I'd like to use the Dual table in Oracle so I made a link
table in Access for the Dual. However, it doesn't work when I run the
following queries:

SELECT sysdate
FROM dual;
(dual is the link table in Access)

or

SELECT col_1
FROM dual

Why is that? Is there any way to accomplish what I want? Thx.

[Luting]

Re: Query Oracle Dual via Access Link Table?

On Jun 24, 10:42 am, Luting <houlut...@gmai l.comwrote:

Hi everyone,
>
I am working on a project using Access as the frontend of a Oracle
database. I'd like to use the Dual table in Oracle so I made a link
table in Access for the Dual. However, it doesn't work when I run the
following queries:
>
SELECT sysdate
FROM dual;
(dual is the link table in Access)
>
or
>
SELECT col_1
FROM dual
>
Why is that? Is there any way to accomplish what I want? Thx.

Problem resolved. I need to use pass-thru queries not link tables.
Thank you all anyway.