-
ADO & textfile
I'm reading a text file into an ADO recordset, then sticking that into an access table. In my ide the program works fine (of course), but the exe on the network is skipping the first line in the text file on occassion. Sometimes it works fine, sometimes it skips it. I've movedfirst etc and tried all kinds of stuff but nothing has worked, and I'm unable to reproduce the behavior at my desk, works fine from there everytime. Anyone know why the first line in a text file would be skipped when being read into an ado recordset?
-
You have probably already checked this, but the first thought that crosses my mind is: Are you using th exact same text file for your test as the users are using? Same exact path and file name? If yes, then you might try posting a sample of one of the text files that is not working here.