set index on linked dbf

[Randal]

Access is linked to a very large dBase IV file - too large to import. Is
there a way to set an index on this linked table to speed up queries?

 

[Joe Fallon]

Not sure if this will actually help speed things up but....

You can create a "Fake" index in Access that tells Access which columns make
a Unique record in the linked table. The index is only used by Access is
completely unknown to the Server.

The following example creates an index on an ODBC linked table. The table's
remote database is unaware of and unaffected by the new index. The following
example won't work if you simply paste it into Microsoft Access; you first
need to create an ODBC linked table called OrderDetailsODBC.

(CREATE INDEX Statement in Help has some examples)

CREATE UNIQUE INDEX OrderID ON OrderDetailsODBC (OrderID);

 

[Randal]

Thanks!

This works great on 2 of the tables because they have a field that works as
the primary key. For my third table there is not a field or set of fields
that are unique. Do you know if there are switches to create "Indexed - Yes
(Duplicates OK)" which I could apply to the foreign key?