• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

dBase IndexKey in VB with Accessfiles?

I must use an indexkey like left(y,x) from a dBase indexfile. How works it on Access Files? I try to set: idx.createFields("left(y,x)"), but this can't work!
How can I use functions in access indexkeys???
0
lucyjimmy
Asked:
lucyjimmy
1 Solution
 
lucyjimmyAuthor Commented:
Adjusted points to 150
0
 
cymbolicCommented:
This will not work in Access.  It ws a provision only in Dbase systems to place a function in a key expression, but not a real good idea for performance even there!  To simulate some of the same capability, I have had to reformat my .dbf files by breaking down larger fields that are really concatenated data, into unique shorter fields in the .dbf file.  Then you can run a normal index on the component pieces, or a multicolumn index as well in Access.

You just can't use an index that contains a function in Access. You have to find some way to work around it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now