Connectivity from MS Access to Oracle

This probably isn't the right forum but here goes:
I have a user that is trying to connect from MS Access to Oracle. We can co
nnect and see the Oracle data in MS Access but I can't modify it. Supposedl
y that had it working on a different machine that has been replaced but we c
an't get it to work now. W
e've tried using Microsoft ODBC for Oracle v. 2.575.1022.00 and two or three
different versions of Oracle for ODBC, but they all get the same results.
We've even tried connecting to Oracle as the table owner - still read-only a
ccess.
Any help would be greatly appreciated. If I should be posting this to a dif
ferent newsgroup, please let me know which one / where!
Thanks,
Mike Stuart
mstuart_nospam@.gates.comMake sure you specify a primary key or unique identifier
when you link the tables.
You may want to post this in the following newsgroup:
microsoft.public.access.odbcclientsvr
-Sue
On Tue, 9 Mar 2004 12:41:09 -0800, "mikron2"
<anonymous@.discussions.microsoft.com> wrote:

>This probably isn't the right forum but here goes:
>I have a user that is trying to connect from MS Access to Oracle. We can connect a
nd see the Oracle data in MS Access but I can't modify it. Supposedly that had it w
orking on a different machine that has been replaced but we can't get it to work now
.
We've tried using Microsoft ODBC for Oracle v. 2.575.1022.00 and two or three different ver
sions of Oracle for ODBC, but they all get the same results. We've even tried connecting t
o Oracle as the table owner - still read-only access.
>Any help would be greatly appreciated. If I should be posting this to a di
fferent newsgroup, please let me know which one / where!
>Thanks,
>Mike Stuart
>mstuart_nospam@.gates.com|||Dear Sue,
I'm using the SQLconfigdatasource to create a DSN for Oracle and the functio
n doesn't work with Windows XP.
If I remove the old DSn and runs the code, the DSN is created but the connec
tion to the Oracle tables fail. I have realized that if I create the DSN, st
op the code running, open the windows control panel and open and close the c
onfiguration of DSN the con
nection to the tables works fine.
I think that after the SQLconfigdatasource the DSN is created but lack somet
hing ( maybe an update of the WIN register) to work properly. This case does
nt happen in WIN 2000.
Can you help me? If you can answer me in my email : mauricio.farto@.itelefoni
ca.com.br
Thanks in advance.