Properties for linked text file

[ChoonBoy]

My Acc03 is linked to a large text file (about 500,000 rows).

The text file is used to generate information for several queries, forms and
reports. Because of its size, I am hoping to set Field6 to an index field to
improve performance.

I am not able to do this. Is there another work around for this.

Thanks in advance

 

[BruceB]

My Acc03 is linked to a large text file (about 500,000 rows).

The text file is used to generate information for several queries, forms and
reports. Because of its size, I am hoping to set Field6 to an index fieldto
improve performance.

I am not able to do this. Is there another work around for this.

Thanks in advance

Create a table with the appropriate indexes first and then import your
text file into that table. Use the table instead of the linked text
file as the basis for your queries, forms, and reports.

Bruce