Converting Access Queries to Run on an Oracle server

Discussion in 'Access Conversion' started by Rocky5, Jan 14, 2009.

  1. Rocky5

    Rocky5 Guest

    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, Jan 14, 2009
    #1
    1. Advertisements

  2. Rocky5

    Jeff Boyce Guest

    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
     
    Jeff Boyce, Jan 14, 2009
    #2
    1. Advertisements

  3. Rocky5

    Rocky5 Guest

    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
     
    Rocky5, Jan 15, 2009
    #3
  4. Rocky5

    Alex Dybenko Guest

    Alex Dybenko, Jan 15, 2009
    #4
  5. Rocky5

    magy Guest

    I do not kwon you.
     
    magy, Jan 18, 2009
    #5
  6. est ce que quelqu'un parle français
     
    elodie legarnd, Jan 21, 2009
    #6
  7. Rocky5

    Jeff Boyce Guest

    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
     
    Jeff Boyce, Feb 18, 2009
    #7
  8. Rocky5

    reginka Guest

    gil
     
    reginka, Mar 6, 2009
    #8
  9.  
    Cameros Casado, Jul 2, 2009
    #9
  10.  
    Cameros Casado, Jul 5, 2009
    #10
  11. Rocky5

    Guest Guest

     
    Guest, Jul 13, 2009
    #11
  12. Rocky5

    rene Guest

     
    rene, Aug 27, 2009
    #12
  13. Rocky5

    markhenry Guest

     
    markhenry, Aug 29, 2009
    #13
  14. Rocky5

    Jeff Boyce Guest

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

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP
     
    Jeff Boyce, Aug 31, 2009
    #14
  15.  
    Rolande Serge, Oct 5, 2009
    #15
  16. Hello



     
    Stephanie McCorkle, Oct 7, 2009
    #16
  17. Rocky5

    o;; Guest

     
    o;;, Oct 10, 2009
    #17
  18. Rocky5

    o;; Guest

     
    o;;, Oct 10, 2009
    #18
  19. Rocky5

    o;; Guest

     
    o;;, Oct 10, 2009
    #19
  20. Rocky5

    o;; Guest

     
    o;;, Oct 10, 2009
    #20
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.