Linked table

[Hyper]

Hi, I created a linked table using ODBC from my Point of
Sales System. The table is pretty big, about 100,000
records and then I do Macro Tranfer Text it takes forever
to execute. I tried to index the table, but it says since
the table linked it can not save any changes.

Any ideas how I can index it or do something else to run
queries faster ?

Thanks.

 

[Joe Fallon]

Not quite sure what you are trying to do 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);