Aonnect Access as a Front ENd with ORACLE Back End

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • bhapate1
    New Member
    • Aug 2007
    • 9
    #1

    Aonnect Access as a Front ENd with ORACLE Back End

    Hi All

    I want to connect Access as a FRONT END and ORACLE as a BACK END…
    I want to connect both of them to pull data from ORACLE into ACCESS interface.

    Thanks,
    Bhavin
    Tags: None
    • Jim Doherty
      Recognized Expert Contributor
      • Aug 2007
      • 897
      #2
      Originally posted by bhapate1
      Hi All

      I want to connect Access as a FRONT END and ORACLE as a BACK END…
      I want to connect both of them to pull data from ORACLE into ACCESS interface.

      Thanks,
      Bhavin
      The easy way LINK the tables via ODBC

      File....Get External Data...Link Tables....Files Of Type...ODBC Databases...Cre ate your DSN on the client machine and follow the prompts. The tables will then appear in the database window.

      Other than that you are into DSNless connections in code using unbound forms and communicating using recordset collections

      Regards

      Jim

        Comment

        Previous template Next
        Working...