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,763
    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,424
    Provided Answers: 8
    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

    See clear as mud


    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  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
  •