Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    87

    Unanswered: DLookup -> Timeout

    Hello everybody...
    I've got a little problem using DLookups in VB (Access) with MS Sql 7.0.
    I'm using it to get some data while looping trough a recordset (while not rs.eof ... dlookup ... wend) - the problem is - always on the 81'st recordset I get a timeout ... i wait a couple of seconds and then the code gets halted, press play again and it works... does anybody know a solution to this problem? should i do a rs.open instead of a dlookup?

    Thanks for helpin'!

    Greetz - Marc

  2. #2
    Join Date
    Jul 2002
    Posts
    87
    extension of upper thread...
    I've tried with an rs.open also, same problem after 80 records...
    It seems like a max-login restriction in the sql server or something...

    Anyone any Idea???

    thx

Posting Permissions

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