Solved

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

Posted on 2002-03-26
6
157 Views
Last Modified: 2010-05-02
Hello,

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.
0
Comment
Question by:slavikn
6 Comments
 
LVL 1

Expert Comment

by:baltman
ID: 6897705
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...
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q108149

Here's a solution for the slow functioning of FindFirst, or at least a way to work around it....
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q108380

Here's some more information on how to use Seek:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q110497


Hope this helps!

BA
0
 
LVL 49

Expert Comment

by:Ryan Chong
ID: 6898071
If the operation is not frequently use, then try to use "Where" condition in SQL rather than use FindFirst.
0
 
LVL 1

Author Comment

by:slavikn
ID: 6898717
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!
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:slavikn
ID: 6912385
I didn't get an answer.
0
 
LVL 27

Expert Comment

by:Asta Cu
ID: 7143857
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.
Asta
0
 
LVL 6

Accepted Solution

by:
Mindphaser earned 0 total points
ID: 7144082
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now