My planned design was to use a VBA script which would go something like this:
Code: Select all
for each record in the table,
extract the URL (currently stored in a memo)
connect to the website's TCP port 80
if server returns an error message (404, 501, etc.)
store the URL and error message in a temporary table
else
scan the page for the keyword
if the keyword is not found
store the URL and missed word in a temp table
generate report from the temp table(s)I think it would be trivial to use Perl or Java to handle the connections and store the results back to the database, but since the client wants the reports done in Access, it would mean a two step process which may not be acceptable. I don't see any way to do it in VB 6.0, either, though I have not pursued that line of inquiry too deeply. I am certain it could be done in VB.NET, but neither I nor the client have been using it to date, and we would rather avoid adding any new development tools to those already in use. In any case, using VB would mean using Crystal Reports instead of the Access Report Generator, which may not be acceptable to the client.
I keep thinking I have overlooked something important. I have already taken longer with this assignment than I should have, and the client is understandably displeased. Even a negative answer, if definitive, would allow me to proceed, even if it means discontinuing the contract.
