Converting Access Queries to Run on an Oracle server


R

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
 
J

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
 
R

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
 
J

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
 
C

Cameros Casado

Rocky5 said:
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
 
C

Cameros Casado

Rocky5 said:
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
 
J

Jeff Boyce

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top