In addition to Karsten's excellent advice I'd strongly advise using the
drivers from Oracle, not the Microsoft one, which is essentially frozen
somewhere around 7.3.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Rita" <rita.wilemon_at_marioncountyfl.org> wrote in message
news:da9356f9.0305060944.780984a_at_posting.google.com...
> Does anyone have any ideas on how to create a MSQuery using oracle
> tables? Problem seems to occur when you have a one to many
> relationship between oracle tables. When you access the fields in
> word the data from the tables that could have many records related to
> the one are blank. If you do one to one relationship queries
> everything works ok.
>
> Also MS Word seems to only work when you use a userid that is the
> owner of the tables. When we use a userid that has read access to the
> tables we get an error or the screen freezes up. Does anyone know if
> it is a requirement for the userid to be the owner of the tables when
> accessing the queries? (This seems kind of odd.)
Received on Wed May 07 2003 - 03:12:39 CDT
