<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=155144017-04022003><FONT face=Arial color=#0000ff size=2>dim f
as long</FONT></SPAN></DIV>
<DIV><SPAN class=155144017-04022003><FONT face=Arial color=#0000ff size=2>dim
strTemp as long</FONT></SPAN></DIV>
<DIV><SPAN class=155144017-04022003><FONT face=Arial color=#0000ff
size=2>f=freefile</FONT></SPAN></DIV>
<DIV><SPAN class=155144017-04022003><FONT face=Arial color=#0000ff size=2>Open
"C:\MyFiles\ServerA.txt" for binary access read as f</FONT></SPAN></DIV>
<DIV><SPAN class=155144017-04022003><FONT face=Arial color=#0000ff
size=2>strTemp=space(LOF(f))</FONT></SPAN></DIV>
<DIV><SPAN class=155144017-04022003><FONT face=Arial color=#0000ff size=2>get
f,,strtemp</FONT></SPAN></DIV>
<DIV><SPAN class=155144017-04022003><FONT face=Arial color=#0000ff size=2>Close
f</FONT></SPAN></DIV>
<DIV><SPAN class=155144017-04022003><FONT face=Arial color=#0000ff
size=2>Debug.Print strTemp</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Roz Clarke
[mailto:roz.clarke@donnslaw.co.uk]<BR><B>Sent:</B> Tuesday, February 04, 2003
5:20 AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B>
[AccessD] OT: Getting data from .txt into VB or web page<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=719151411-04022003>Hello
all</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=719151411-04022003>This isn't an
Access question but I can't think of any better people to
ask.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=719151411-04022003>I've been tasked
with writing a logon application for our Terminal Server network that will
take the user's username & password, and then query a text file to find
out which of the application servers is the least busy, before connecting the
user to that server.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=719151411-04022003>The text file will
be in the format</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003>serverA,18</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003>serverB,4</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003>serverC,12</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=719151411-04022003>etc., where the
number is the number of currently connected users.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=719151411-04022003>I don't even know
where to start. The notwork guy is keen for me to make it browser based, but I
don't see what advantages that would have over a little VB app. Either way I
don't know how to get the data out of that .txt file.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=719151411-04022003>Is that enough
info for anyone to help? Any pointers?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003>TIA</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=719151411-04022003>Roz</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML>