[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • 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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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