here you will <a href="http://oraclevsmicrosoft.blogspot.com/2004/10/introduction.html">
find a vb code to refresh your Oracle tables in Access</a>
mikes_at_cs.indiana.edu (Michael Squires) wrote in message news:<cki4ej$8ac$1_at_hood.uits.indiana.edu>...
> In article <tjknm097fmntbqfthf7ebjucjfl6vtd0ii_at_4ax.com>,
> Sybrand Bakker <sybrandb_at_hccnet.verwijderdit.nl> wrote:
> >On Tue, 12 Oct 2004 14:11:08 +0200, "Déian" <dvikov_at_qualigrag.com>
> >wrote:
> >
> >>Hello everyone,
> >>
> >>I have many problems when try to connect MSAccess to an Oracle database, do
> >>you know how to do this (which ODBC driver, what parameters)
> >>
> >>Thanks
> >>
> >
> >
> >It basically requires
> >a) setting up normal connectivity to Oracle
> >b) setting up an appropiate entry in the ODBC administrator.
> >And that's all there is to it.
>
> Not with 10g, however; I've been unable to link Oracle tables using the
> Oracle 10g client connecting to a 10g clustered environment. Using the 9i
> client works, but the new recyclebin feature causes problems (if a table
> is dropped but not purged and then recreated Access will continue to see
> the dropped table and not the new table with the same name).
>
> Access versions are 2002 and 2003.
>
> The result of linking is that the table structure is displayed, but all
> fields contain "#Deleted" instead of the value. This appears to be
> related to an old Access 97 bug caused by Access being unable to handle
> the variable definitions provided by Oracle.
>
> Mike Squires
> msquires at iga.state.in.us
Received on Sat Oct 30 2004 - 09:18:45 CDT
