Re: odbc connect from MSAccess to Oracle

MS Access does some weird caching thing which after a good year of using it everyday I am still trying to figure out. But my guess is you table is changing rapidly?

I can reproduce the same thing but viewing the Oracle table from Access, then going into SQL Worksheet or something and DELETEing a pile of records from that table. Hey presto, look back at the table for which you left the view open in Access and half the records say #deleted...

It's never really bothered me, but maybe there are some settings in regards to how often this refreshing occurs in the Access Options...

Tony

Larry Helwig <lhelwig_at_mediaone.net> wrote in message news:BMqP6.15950$9G.104764_at_typhoon.mw.mediaone.net...
> Delete the link and then reattach it.
>
> "Bill Koob" <wkoob_at_minn.net> wrote in message
> news:3b0e50a6.2406086_at_News2.Minn.Net...
> > List,
> > I have a table in oracle that when viewed from within Oracle has no
> > apparent problems - everything works quite well with Oracle & its
> > tools.
> > When linked with ODBC to MSAccess it shows a significant number of
> > records with deleted in each field of the record.
> > Any ideas.
> >
> > When I imported the data (ascii delimted) data exceptions showed up
> > I fixed the data - deleted all the records in the table and imported
> > the data again. It may be my imagination but many of the records
> > with deleted in the fields seem to be records that had problems in
> > the previous import.
> >
>
>
Received on Thu Jun 07 2001 - 07:40:27 CDT