Need help with Access 97 and Oracle 9i

Hello all,

I've got a FE/BE application, and I'd like to change the BE to linked
tables. These table are in an Oracle database. I'm working on testing this
change and I'm stuck. I'm hoping someone can help, or at least get me
pointed in the right direction. Google has failed me (likely due to user
error).

I'm using Access 97 (and have to continue to do so, so no upgrade
recommendations). The backend sits on a server, and all the FEs point to
that location. I'd like to change the existing tables in the BE to linked
tables. The switch BE versions with (hopefully) to effect on the user.

I'm connecting to Oracle 9i. I've attempted to create an ODBC connection,
but it's constantly fails. And nothing I've done has solved the issue.
After a bit of googling, I found that the Microsoft ODBC Driver doesn't
support anything beyond Oracle 8i (http://support.microsoft.com/kb/244661).
The recommended solution in that DB article is a .NET solution. I can't see
how that could work with Access 97, so I believe I need a different solution.

I don't have any administrative control over the Oracle DB, so I have (to
try) to get this working through Access 97, if possible. I haven't been able
to find an ODBC driver for use in Access 97 for Oracle 9i. That might solve
my whole issue.

I'm looking for anything I can get; suggestions, recommendations, required
reading, criticism. Appreciate everyone's response.

If anyone has any sites they would recommend covering ODBC related
information, please pass them on.

Thanks,
Jay
--
Disregard, this is so I can find my post later.
***postedbyJay***
.

Relevant Pages

  • Re: Need help with Access 97 and Oracle 9i
    ... I'm trying to make the connection on the my local machine. ... discussed using ODBC driver to connect to Oracle. ... I found that the Microsoft ODBC Driver doesn't ... I'm looking for anything I can get; suggestions, recommendations, ...
    (microsoft.public.access.externaldata)
  • Re: Need help with Access 97 and Oracle 9i
    ... Microsoft Office/Access MVP ... discussed using ODBC driver to connect to Oracle. ... I found that the Microsoft ODBC Driver doesn't ... I'm looking for anything I can get; suggestions, recommendations, ...
    (microsoft.public.access.externaldata)
  • Re: Need help with Access 97 and Oracle 9i
    ... These table are in an Oracle database. ... I've attempted to create an ODBC connection, ... I found that the Microsoft ODBC Driver doesn't ... I'm looking for anything I can get; suggestions, recommendations, required ...
    (microsoft.public.access.externaldata)
  • SUMMARY: Hardware for Oracle Serverq
    ... on your many recommendations. ... A number of you recommended I run Oracle on Linux at my price point ... particularly around how well the thread-sharing model works ... applications on Niagra chips, very happily. ...
    (SunManagers)
  • Re: Need help with Access 97 and Oracle 9i
    ... Not sure if our google results were the same. ... discussed using ODBC driver to connect to Oracle. ... I found that the Microsoft ODBC Driver doesn't ... I'm looking for anything I can get; suggestions, recommendations, required ...
    (microsoft.public.access.externaldata)
Loading