Re: Questions regarding MS ACCESS, ODBC and ORACLE

Arnold Hitch (trident_at_worldgate.com) wrote:
: Has anyone have any comments about problems using MS ACCESS to Oracle
: through ODBC? I have heard there are a number of problems with how ACCESS
: deals with Oracle objects, specifically private and public synonyms. I am
: also curious if any one has successfully had ACCESS perform remote update,
: insert or delete through and Oracle database link.

We don't have any synonyms in our Access/Oracle system, so I cannot comment on that. However, inserts/updates/deletes work fine. The only caveat is that Access requires a unique index on any remote table it must update, so we had to introduce a sequence column to serve as an arbitrary unique key in a few tables.

-- 
========================================================================
"Villains, I say to you now:       |   Mike Carmack
 KNOCK OFF ALL THAT EVIL!"         |   Vulcan Dragon -==(UDIC)==-
    S P O O N !!!!    - The Tick   |   mcarmack_at_freenet.columbus.oh.us