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 - Marcextension 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment