This little project has to be written in VB6
The purpose is to read the contents of an Ms Access table and then decide whether
to update another table with the contents of a text file.
The process
Access MDB name = [login to view URL]
The Text file name = ? [login to view URL]
Both of them will always be in the same folder.
Read the “LptNo?? field in the “users?? table where “UID=1??
If the value in the “LptNo?? field = ? > 1 do nothing.
? Else
Write the contents of the text file into the “LSno?? field from the “lsno?? table where “LN=1??
See the attached MDB and Text file.