Prev: Export to Text File with newline delimiter
Next: Update oracle via Access forms?
From: Luting on 24 Jun 2008 13:42
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.
From: Luting on 24 Jun 2008 15:23
On Jun 24, 10:42 am, Luting <houlut...(a)gmail.com> wrote:
> 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.
 | 
Pages: 1
Prev: Export to Text File with newline delimiter
Next: Update oracle via Access forms?