469,579 Members | 1,198 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

Query Oracle Dual via Access Link Table?

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.
Jun 27 '08 #1
1 2959
On Jun 24, 10:42*am, Luting <houlut...@gmail.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.
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Edwinah63 | last post: by
12 posts views Thread by zwasdl | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.