Re: Access to Oracle - a weird problem of connectivity

Anne - thanks for that - a primary key missing - hmm - it COULD BE!! I'll check tomorrow!! Chris B.

In article <91ar39$u7b$1_at_nnrp1.deja.com>,   anolan_at_enabletech.com wrote:
> The only thing that comes immediately to my mind is to check that the
> internet_registrees table in QQ40 has a primary key defined. If not,
> Access will treat it as read-only. (You can look at the Oracle table
> definition in Oracle, or you can look at the Access link to the Oracle
> table in design mode, and click the button that shows you the
 indexes.)
>
> I don't know if your use of the word "replicated" just means that
> everything is (presumably) identical on the 2 servers, or whether some
> Oracle Replication feature (do they have that?) is in use. If the
> latter, maybe this is causing some interference in some way.
>
> Hope this helps,
>
> Anne Nolan
>
> In article <91ap1b$s4s$1_at_nnrp1.deja.com>,
> chrisbrady_at_my-deja.com wrote:
> > Access to Oracle - a weird problem of connectivity
> >
> > We have two Oracle servers QQ03 and QQ40 - both are running Oracle
 8.x
> >
> > On these are identically named tables - creg_members and
> > internet_registrees
> >
> > All four tables have identical access permissions for my logon id to
> > read, append, update and delete records.
> >
> > Using Access 8 on my client PC (running W95) I can link to the
 tables
> > on QQ03. When the two tables on this are opened I can read, append,
> > update and delete records on both of them. OK so far.
> >
> > However, when I link to the replicated tables on QQ40 I can only
 read,
> > append, update and delete records on creg_members. The other table -
> > internet_registrees - is read only.
> >
> > Even weirder is that when I log on to both servers directly - using
 the
> > same logon id that I use when I link to them with Access - I can do
> > all I want - read, append, update and delete records on both tables
 on
> > both servers.
> >
> > So why is it that on identically set up servers with identically
> > replicated tables I can read, append, update and delete records to
 both
> > tables when I logon to the servers directly. But when I use Access
 to
> > link to QQ03 I can also can read, append, update and delete records
 to
> > both tables. But when I use Access to link to QQ40 I can only read,
> > append, update and delete records to one table, whilst the other
> > becomes read only?
> >
> > Any ideas would be gratefully received.
> >
> > Many thanks - Chris B.
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 14 2000 - 23:33:38 CET