Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2002-03-26
6
Medium Priority
?
166 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
[X]
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
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 53

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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

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…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…
Suggested Courses

618 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