Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Questions regarding MS ACCESS, ODBC and ORACLE

Re: Questions regarding MS ACCESS, ODBC and ORACLE

From: Michael Carmack <mcarmack_at_freenet.columbus.oh.us>
Date: 1996/11/25
Message-ID: <57c94p$fva@login.freenet.columbus.oh.us>#1/1

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
Received on Mon Nov 25 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US