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: ACCESS very slow at loading Oracle tables

Re: ACCESS very slow at loading Oracle tables

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: Mon, 18 May 1998 21:37:07 GMT
Message-ID: <3560AA03.D9ABE533@access-laserpress.com>


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

Original text of this message

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