Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: Searching in Access with an ODBC database

    Hi I'm using Access 2003 and running an ODBC database. Searching is very slow unless I untick "search fields as formatted". Is there anyway I can turn that off by default?

    Any help would be greatly appreciated!

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Welcome to the forums

    I'm not sure what your code looks like, by are you using the FindRecord Method? If so, have you looked at the fifth argument (SearchAsFormatted)? If not, could you post the code that's giving you trouble so we can have a better idea of what's going on?
    Me.Geek = True

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'm not convinced Lorna is using code to do the search. If you want to change the option for when you hit the find button or when you press CTRL-F, then no, there is no way that I am aware of to change that option as a default.

    The solution may be to use code to do the search.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Mar 2009
    Posts
    2
    Thanks, I'm not using code to do the search, just Find/ Replace within Access.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I don't think there is a way to change the defaults for that.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •