Properties for linked text file

  • Thread starter Thread starter ChoonBoy
  • Start date Start date
C

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
 
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
Click to expand...

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
 
Back
Top