By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,751 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Access ability to create table aliases

P: n/a
My company uses coldfusion to create web applications and we currently
are using TOAD as a front end to creating SQL queries. I was wondering
how is Access compared to TOAD on its ability to provide a front end to
an Oracle database

Also, does Access have the ability to create table Aliases for whenever
you create a query in design view and then view it in SQL view (or does
it have the ability to assign table aliases at all)
My dept. uses access 97 but there are others who have access 2000
installed so if you could provide some suggestions using 2000 as a
model

Aug 3 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Try helping yourself. Test it out. I mean, what's the worst that
could happen? The query would fail?

Alias a table in the QBE grid and click the SQL button. If I remember
right, you may not need the AS keyword in Oracle SQL.

if you create pass-through queries, you'd just use the Oracle dialect
of SQL anyway... Access wouldn't even read the statement.

Aug 3 '06 #2

P: n/a

pi********@hotmail.com wrote:
Try helping yourself. Test it out. I mean, what's the worst that
could happen? The query would fail?

Alias a table in the QBE grid and click the SQL button. If I remember
right, you may not need the AS keyword in Oracle SQL.

if you create pass-through queries, you'd just use the Oracle dialect
of SQL anyway... Access wouldn't even read the statement.
There are few differences between the Access SQL and Oracle SQL one
being the way dates are used. Other than that there isn't much
difference. I create the SQL code using access. If I run the query
and I get the results that I want I copy and paste the code on a
Coldfusion page and that is much easier than trying to type the query
in SQL on my own.

Also I could just copy and paste the code in TOAD and let it decide
what doesn't work and tell me.

I can't just try it I don't have access 2000 on my work computer. I
need to get an approval before i can install it. I can't get an
approval based on "Try Helping yourself whats the worst that could
happen you could fail

Aug 3 '06 #3

P: n/a
"rudodoo" <ra*********@gmail.comwrote in
news:11**********************@m79g2000cwm.googlegr oups.com:
>
pi********@hotmail.com wrote:
>Try helping yourself. Test it out. I mean, what's the worst
that could happen? The query would fail?

Alias a table in the QBE grid and click the SQL button. If I
remember right, you may not need the AS keyword in Oracle
SQL.

if you create pass-through queries, you'd just use the Oracle
dialect of SQL anyway... Access wouldn't even read the
statement.

There are few differences between the Access SQL and Oracle
SQL one being the way dates are used. Other than that there
isn't much difference. I create the SQL code using access.
If I run the query and I get the results that I want I copy
and paste the code on a Coldfusion page and that is much
easier than trying to type the query in SQL on my own.

Also I could just copy and paste the code in TOAD and let it
decide what doesn't work and tell me.

I can't just try it I don't have access 2000 on my work
computer. I need to get an approval before i can install it.
I can't get an approval based on "Try Helping yourself whats
the worst that could happen you could fail
You said you had Access 97. To alias a table in either 97 or
2000 is just a matter of changing the value of the alias
property.

BTW, I have found that it is a lot easier to get forgiveness
than approval.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Aug 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.