Re: Access to Oracle - a weird problem of connectivity

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/ Received on Thu Dec 14 2000 - 17:05:04 CET