Forum Moderators: open

Message Too Old, No Replies

retrive info from a file and compare it to a access db

retrive info from a file and compare it to a access db

         

mavrick

10:18 am on Mar 11, 2004 (gmt 0)

10+ Year Member



hi all

i have a problem... and not sure all of the problem can be done in asp.

Ok! i need to execute a program that will compare the info in a .dat file to info in a access db. i have done some research and so far i can not seem to find a solution or any body who has this problem..

i am not used to using VB6, which i think this program has to written in... but if there is any thing that asp can do that to help ,please do tell.

o! another think this script has to run and check all the .dat files in a folder every 5 min.

o boy!

please could somebody help!

duckhunter

1:22 am on Mar 12, 2004 (gmt 0)

10+ Year Member



The functionality can be accomplished through ASP with the use of the FileSystem Object and ADO queries to the Access DB.

The problem is having to do it every 5 minutes. You would need to refresh or open the webpage every 5 minutes. A Windows Server (VB6) is what you will need. Write the VB6 code and register it as a service either with the NTSVC.ocx control or SRVRANY.EXE. Have the service start Automatically so when the box reboots, it runs at startup.