Results 1 to 3 of 3
  1. #1
    azirion is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2011
    Posts
    7

    SEARCH problems with Access and MySql

    Hi



    I have a front end Access program on my local computer based on a MySql database stored on a server, using ODBC to connect. In the db I have like about 3000 records.

    I inserted a Search button on the form, which works fine if I should make a search using the Whole Field, it lasts like 4 seconds to find the record Im looking for.

    My problem is that if I try to search a field using Match Any Part of Field, it takes like forever to find it (like 8 minutes).

    My form is based on a query, but when I do this search I notice too much internet activity, like if the search is being performed one by one on the server instead of my local query (Im I making sense?)

    Is there something I can do to make this search more efficient?

    Thank you for any help.

  2. #2
    azirion is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2011
    Posts
    7
    Extra info:

    I did a search directly into the query table, with the search button on the Access main menu, and it came out with the same result... took forever

  3. #3
    azirion is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2011
    Posts
    7
    Problem solved. Thank you

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access to SQL or MySql
    By Randy in forum Access
    Replies: 6
    Last Post: 08-05-2011, 08:38 AM
  2. MySQL & Access
    By Scorpio11 in forum Database Design
    Replies: 3
    Last Post: 05-21-2011, 02:32 PM
  3. Replies: 4
    Last Post: 01-11-2010, 11:41 PM
  4. Using Access and going to Mysql
    By fsmikwen in forum Programming
    Replies: 1
    Last Post: 11-26-2009, 01:15 PM
  5. Access database to Mysql
    By fsmikwen in forum Access
    Replies: 4
    Last Post: 11-16-2009, 05:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums