Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2002-03-26
6
159 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 51

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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

856 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