Hello friends,

   I want to run a file(asp page) daily at 12:30 PM and 06:00 PM automatically. I tried scheduled tasks. But it is able to run only programs(.exe)

But my file is in this path \\server\dfb\production\attendance\attrep.asp

How can i do this. I think we can do using wSH, but i am not sure how to write using this. Can u suggest me to schedule that task?

And, i have scanner(swiping card) to record the attendance. This is stored in seperate database given by vendor. We can export this data to access 97 database format. But my application uses access 2000 format. So, i need to retrieve data from 97DB and insert in my DB. My database is in virtual folder and exported db is in physical path. How can i do this task automatically(w/o manual interaction) at regular intervals(daily ... at the above times).

Thanx in advance.

Hello,

  I got the solution. I did it. This is the code...

on error resume next
dim conn,rs,str1
set conn=createobject("adodb.connection")
conn.provider="Microsoft.Jet.Oledb.4.0"
conn.open "\\server\donfranco\production\attendance\emp. mdb"
conn.beginTrans
str1="delete from attendance"
conn.execute str1
str1="insert into attendance(eventdate,eventtime,cardnumber) select eventdate,eventtime,cardno from EventListTable in '\\rajani\database\CipherAccess.mdb' where len(cardno)>0"
conn.execute str1

if Err.number <> 0 then
    conn.rollbackTrans
else
    conn.commitTrans
end if
conn.close
set conn=nothing