What happens when you use Find in Access Form connected to SQL database?

Posted on 2005-05-07
Last Modified: 2010-03-19
I am using Access as a front end to a SQL 2000 database.  When I use reports based on queries,  I am pretty sure the queries get converted into SQL and sent to the SQL 2000 server.  They are fairly fast...

But what actually happens when a user presses Ctrl-F to do a find on a field in a form.  

They can search the field for whole field, start of field or any part of field, but how does this request actually get to the server, it seems to take forever to return.

Question by:Tgilbert
    LVL 21

    Accepted Solution

    If you really want to know exactly what is being sent to the server, set up a profiler trace to run against the SQL database, start it, do a find in Access, then look at what was sent to the SQL engine.

    If the field being searched is indexed and the search is for start of field, it should be reasonably quick.  If they are searching in Access for: Like *whatever*, then the whole table is getting scanned.
    LVL 34

    Assisted Solution

    "But what actually happens when a user presses Ctrl-F to do a find on a field in a form. "

    It most ALWAYS results in a table scan.  Although, it really depends on the object the form is bound to.
    LVL 21

    Expert Comment

    Did it work?

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    730 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

    16 Experts available now in Live!

    Get 1:1 Help Now