Converting Access Queries to Run on an Oracle server

  • Thread starter Thread starter Rocky5
  • Start date Start date
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
 
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
 
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
 
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
 
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
Click to expand...
 
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
Click to expand...
 
If you simply "link" to the Oracle tables, Access handles the
conversion/translation.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top