Results 1 to 5 of 5
  1. #1
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78

    after migrating to sql server my query is running slow

    i have a split access database (access front-end and access back-end) speed of running query is okey. i decided to up-size access database with access 2010 wizard to sql server. i got some error about different length in related field , i correct error by decrease field length from 255 to 50 and equal them. after up-sizing again i did not get any error but now speed of my running queries in (access-front-end and sql server back-end) is slower than when it has been splited both in access. i do not know how to solve this problem.

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Change your queries to pass-thru, that is the fastest way of getting data from external links.

  3. #3
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It might also be instructive to see the queries. Are they joining SQL tables to local tables? Do they have functions in them that SQL Server doesn't understand?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78
    i change my queries to pass-thru and my problem has been solved.

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

Similar Threads

  1. Slow running query
    By shawnvon in forum Queries
    Replies: 5
    Last Post: 08-29-2016, 02:49 PM
  2. Replies: 4
    Last Post: 05-04-2016, 06:59 AM
  3. Query not working after migrating to SQL Server 2014
    By Esmatullaharifi in forum Queries
    Replies: 7
    Last Post: 04-18-2015, 05:21 AM
  4. Replies: 12
    Last Post: 11-26-2013, 03:37 PM
  5. Query running VERY slow
    By purple_kittykat in forum Queries
    Replies: 4
    Last Post: 07-31-2011, 12: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