Converting Access Queries to Run on an Oracle server

[Rocky5]

Hello;

I have an access db front end and sql server backend. how painful is it to
convert this to work on an oracle server backend. Any help would be much
appreciated

Thanks

[Jeff Boyce]

If your queries are located in Access (rather than in the SQL-Server
backend), you don't really need to do anything. When you link to the tables
in <fill in your backend server here>, the ODBC connection handles the
translation.

I believe you can simply "point to" (link to) the new tables and start
running Access queries.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it to
convert this to work on an oracle server backend. Any help would be much
appreciated
Thanks

[Rocky5]

Many thanks Jeff ! I'll try that.

One more thing, how do I do a DSNLESS oracle server connection

1. Through ODBC
2. via code where the event of connection happens once a button is clicked.
I plan to either connect on form open or on "connect" button click.
3. via user login form to the database (Generic user made ) login form.
some Sample code would be greatly appreciated


Thanks

Rocky

Post by Jeff Boyce
If your queries are located in Access (rather than in the SQL-Server
backend), you don't really need to do anything. When you link to the
tables in <fill in your backend server here>, the ODBC connection handles
the translation.
I believe you can simply "point to" (link to) the new tables and start
running Access queries.
Regards
Jeff Boyce
Microsoft Office/Access MVP

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks

[Alex Dybenko]

Hi,
have a look here:
http://www.accessmvp.com/DJSteele/DSNLessLinks.html

then you should use Driver={Microsoft ODBC for Oracle};
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Post by Rocky5
Many thanks Jeff ! I'll try that.
One more thing, how do I do a DSNLESS oracle server connection
1. Through ODBC
2. via code where the event of connection happens once a button is
clicked. I plan to either connect on form open or on "connect" button
click.
3. via user login form to the database (Generic user made ) login form.
some Sample code would be greatly appreciated
Thanks
Rocky

Post by Jeff Boyce
If your queries are located in Access (rather than in the SQL-Server
backend), you don't really need to do anything. When you link to the
tables in <fill in your backend server here>, the ODBC connection handles
the translation.
I believe you can simply "point to" (link to) the new tables and start
running Access queries.
Regards
Jeff Boyce
Microsoft Office/Access MVP

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks

[magy]

I do not kwon you.

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it to
convert this to work on an oracle server backend. Any help would be much
appreciated
Thanks

[elodie legarnd]

est ce que quelqu'un parle français

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it to
convert this to work on an oracle server backend. Any help would be much
appreciated
Thanks

[savoyechristian]

salut de belgique demande telechargement musique nous envoyer musique

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it to
convert this to work on an oracle server backend. Any help would be much
appreciated
Thanks

[Jeff Boyce]

You don't describe 'how' you are accessing the SQL-Server data.

If you are using an ODBC driver, it might be as simple as creating a new
ODBC driver to connect to the Oracle data, then linking to the Oracle
tables. If your (Oracle) table names are the same as your (SQL-Server)
table names, you wouldn't even need to change your queries!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Post by savoyechristian
salut de belgique demande telechargement musique nous envoyer musique

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks

[reginka]

gil

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it to
convert this to work on an oracle server backend. Any help would be much
appreciated
Thanks

[Cameros Casado]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it to
convert this to work on an oracle server backend. Any help would be much
appreciated
Thanks yo hablo español

[b***@hotmail.com]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[rene]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[Rolande Serge]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[Stephanie McCorkle]

Hello

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[unknown]

Hello

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[unknown]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is
it to convert this to work on an oracle server backend. Any help would
be much appreciated
Thanks yo hablo español

[miguel]

hi, hola como estan

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is
it to convert this to work on an oracle server backend. Any help would
be much appreciated
Thanks yo hablo español

[Megha Raj Sapkota]

Hi check mail

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is
it to convert this to work on an oracle server backend. Any help would
be much appreciated
Thanks yo hablo español

[n***@hotmail.com]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is
it to convert this to work on an oracle server backend. Any help would
be much appreciated
Thanks yo hablo español

[unknown]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[druenne]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[ben belgacem walid]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is
it to convert this to work on an oracle server backend. Any help would
be much appreciated
Thanks yo hablo español

[derick]

kids

[drummerboy]

you should really watch what you say, you can offend someone. and you should
never clone.

kids

[David Jennings]

SEND $

Post by drummerboy
you should really watch what you say, you can offend someone. and you
should never clone.

kids

[aleta]

hi

[markhenry]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[Jeff Boyce]

If you simply "link" to the Oracle tables, Access handles the
conversion/translation.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[unknown]

Post by Jeff Boyce
If you simply "link" to the Oracle tables, Access handles the
conversion/translation.
Regards
Jeff Boyce
Microsoft Office/Access MVP

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is
it to convert this to work on an oracle server backend. Any help would
be much appreciated
Thanks yo hablo español

[unknown]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[unknown]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[unknown]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[unknown]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[unknown]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it
to convert this to work on an oracle server backend. Any help would be
much appreciated
Thanks yo hablo español

[Cameros Casado]

Post by Rocky5
Hello;
I have an access db front end and sql server backend. how painful is it to
convert this to work on an oracle server backend. Any help would be much
appreciated
Thanks yo talk espanish