Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ACCESS very slow at loading Oracle tables
You absolutely must have a primary key on the table. Period. If you
don't, you get fast read-only access, but that's all.
Troy Perchotte wrote:
>
> When I try to view the contents of an attached Oracle8 table from within
> Access 97, the computer takes about 10+ seconds just to display the
> first page of records, and 2 seconds thereafter to move the cursor
> between records. I have about 100 fields in this table, and if I reduce
> the number of fields, the display time also decreases a little; however,
> nothing changes with respect to the number of records.
>
> I though after posting this problem here last month, that I found a
> solution. :( When linking an oracle table, Access prompts the user to
> select which field or fields identify each record's uniqueness. By not
> selecting any field, the display time was instant, and my problem was
> solved; however, I found out after, that the linked tables weren't
> updateable this way.
>
> How do I link a table from Access97, with reasonable speed, and not be
> read-only?
>
> Thanks in advance,
>
> Troy Perchotte
Received on Mon May 18 1998 - 16:37:07 CDT
![]() |
![]() |