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.
Who is Participating?
MindphaserConnect With a Mentor Commented:
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
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.
Get expert help—faster!

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

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!
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.
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.

All Courses

From novice to tech pro — start learning today.