Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Mar 2003
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL server ecords not showing up (Access XP)

    I created an SQL query which give over 9000 records when run from the SQL server query analyser. But if I run the same query from Ms Access query grid, it is only returning 156 records. I have tweaked the Tools >. Options > Advanced tab to set the default max record to 10000 but this does not seems to have any effect on the number of records pooled from the server. Please help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: SQL server ecords not showing up (Access XP)


  3. #3
    Lounger
    Join Date
    Mar 2003
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL server ecords not showing up (Access XP)

    I have created an Access project database that is using records stored on the SQL server. On one of the tables, there is more than 300000 records. But when I tried to see the table from Access project, I can only see 5000 records.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: SQL server ecords not showing up (Access XP)

    I hope someone else can help you, this is outside my field.

  5. #5
    Star Lounger
    Join Date
    Sep 2002
    Location
    Hastings, Sussex, England
    Posts
    67
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL server ecords not showing up (Access XP)

    Deekatz,

    you haven't actually said if Hans' suggestion was any help. Instead, you've launched into a second question. Sticking to your first question, if the KB article didn't cover your situation, more information is needed. I use Access and SQL Server 2000 together all the time, and there's normally an explanation for such symptoms (quite often the two queries are actually slightly different, or dates are not being formatted correctly, or nulls are handled differently). If you'd like to post the SQL that you are using, I'll see if I can come up with any ideas.

  6. #6
    Lounger
    Join Date
    Mar 2003
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL server ecords not showing up (Access XP)

    Sorry. But no, the knowledge base wasn't of any help. I found a solution though. Instead of the creating the query within MS Access project I just created a view of base on the same select statement on the server. This seems to work. Thanks anyway.

Posting Permissions

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