ODBC problem with linked tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ron bromwell (anonymous_at_discussions.microsoft.com)
Date: 04/01/04 

Date: Thu, 1 Apr 2004 11:33:07 -0800

I have an Access database that has linked tables to the
tables in my oracle DB. Every time I make a change to the
database and send it to the users, they have OBDC
failures until I re-link the tables. Any ideas on how I
can elevate this problem?

Relevant Pages

  • Access and Linked tables to Oracle
    ... In the past I created an Access database front end for our end users ... for the purposes of querying our Oracle data. ... Something around 2 seconds if Oracle has cached the query ... is getting defined for the primary key in the large Oracle table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: oracle and exporting data for a .mdb file
    ... >still needs to go the access database where it IS EXPECTING a .mdb file. ... as this will be considered a change request and more ... Can oracle do it, and where can I find out how to do ...
    (comp.unix.programmer)
  • Re: oracle and exporting data for a .mdb file
    ... > still needs to go the access database where it IS EXPECTING a .mdb file. ... Can oracle do it, and where can I find out how to ... But, given your constraints, what I would do is connect a Windows machine ...
    (comp.unix.programmer)
  • Re: oracle and exporting data for a .mdb file
    ... What format does MONARCH expect? ... >still needs to go the access database where it IS EXPECTING a .mdb file. ... as this will be considered a change request and more ... Can oracle do it, and where can I find out how to do ...
    (comp.unix.programmer)
  • RE: Update Oracle table from Access table
    ... Create a dynamic xml file by reading values from access database and use this xml file to update oracle database by reading into dataset ...
    (microsoft.public.dotnet.framework.adonet)