Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2010
    Posts
    2

    Unanswered: access linked table long query not working

    I have an access program that have been using linked table through ODBC connection to our SQL Server database. When I sent a query through Access, the Access sometimes just stop responding. It seems if I select too many columns, it will stop working. I'm not sure if the query string is too long (about 500/600 charaters). Could you please let me know how to fix that? Thanks.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,764
    Provided Answers: 19
    Networks are not my forte, but it sounds as if this is a networking problem. My guess is that the connection is being dropped. You say this happens if a fair number of columns are selected the problems shows up; how many records are you talking about returning here?
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,475
    Provided Answers: 11
    I'm Backing Miisingling network

    what about make a Make table query and getting the data local first before running the query

    what I done in the pass

    under the Print bottom
    have a
    1 maketable to pull the data locally
    2 Query it toget some of the data
    3 query that to get more data right
    4 them i run the report.

    now each time the use click the report buttom the data is been rebuilt each time

    Just think out side of the square ?
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  4. #4
    Join Date
    Sep 2010
    Posts
    2
    The query only pulls back a few hundreds rows. not big resultset.

    I tried locally and the query will work with a lot of columns. I also think it's a network issue. But is there any way I could fix it?

    Thanks!

Posting Permissions

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