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

Indexes

I am updateing an Access 97 table.  I have a Primary Key set up on a multiple field index.  To reference the Index from VB My statement is:
rsInvhd.Index = "Rp0753sIndex"
I get no errors but my seek (rsInvhd.Seek "=", strSeek) does not work.  I've checked field and search string lengths.  What's the secret?
0
tneg
Asked:
tneg
  • 2
  • 2
1 Solution
 
deightonCommented:
For multiple keys you need to do

rsInvhd.Seek "=", strkey1,strkey2,strkey3

etc...

If your seaching over a single key, could you set up a single key index?
0
 
deightonCommented:
Experimentation shows that you do need the full key.  Supply the full key data or define a new index with a single key.
0
 
tnegAuthor Commented:
strSeek is built from multiple fields
0
 
tnegAuthor Commented:
It worked by separating the elements rather than having them in 1 variable.
I think I've been doing dbase/Clipper too long
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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