Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Index a TableDef in order to seek through table files

Status
Not open for further replies.

GIJoeFigure

Technical User
Jun 16, 2004
27
0
0
US
Hello. I have been trying for the longest time to set up a table of computer folder pathways like "C:\Tmp\bin" and other data columns using TableDef and CreateField lines. That part now works fine but I would like to take this new table and index a field so I can use the Seek function to find if files exist in each pathway in the table. I keep getting an error saying that "pathway" is not an index. Please help.

 
I forgot to mention, I have been trying this by creating the fields, appending the tabledef, then opening the recordset by the same name. The recordset always has trouble with setting index

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top