I used VBA to retrieve data from DB. DB isn't in local network, So if I run
my programmer to retrieve data from my local computer, I will get right
number of records. however I run it to retriev remote DB , I won't got right
number of records. (e.g.:if I query 100 records, I will get less than 100 and
it's a random number in every time, may be 56 or other number. but I will get
right number in my local computer). I set commandtimeout=40000, I got a
wrong number again. Anyone help me? thanks a lot.
--
Developer
QA Dashboard
Microsoft China Development Centre