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

URGENT: Using "Index" and "Seek" in DataEnviroment


I use DataEnviroment to work with my Access 2000 DataBase. How can I look for records in a certain table using "Index" and "Seek"? "FindFirst" etc work very slowly. That's why I don't want to use it.

You can send me an example to my e-mail: slava_site@hotmail.com  or to publish it here.

Thanks in advance.
1 Solution
Hi slavikn,

Here is the comparison of Seek opposed to Find... methods, with sample codes. Further below are some other links to articles for you to see if you can find other options as well...

Here's a solution for the slow functioning of FindFirst, or at least a way to work around it....

Here's some more information on how to use Seek:

Hope this helps!

Ryan ChongCommented:
If the operation is not frequently use, then try to use "Where" condition in SQL rather than use FindFirst.
slaviknAuthor Commented:
Hi baltman,

All those examples do not work with DataEnviroment. Can you please give me an example for DataEnviroment.


Hi ryancys,

I will use seek a lot, that's why I need something that works very fast.


In a few hours I will get 5 points, so I will increase this question's "price" to 245!
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

slaviknAuthor Commented:
I didn't get an answer.
Asta CuCommented:
This question has never cleared, since you tried to delete it after comments have been added.  The only way to have this deleted or PAQd, is to request it in the Community Support topic area.
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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