User Clicks this link: [login to view URL] Operation Needed on MS Access db using ASP: Table = tblIpUpdate This table has 3 fields: ComputerName LatestUpdated IPNumber Using the value from Server Variables save into the db the following: If Computer name is found then Replace current value of IPNumber with REMOTE_ADDR Replace LatestUpdated value with Current Date and Time If computer name is not found then Add ComputerName in the ComputerName field Add REMOTE_ADDR in the IPNumber field Add Current date and time in LatestUpdated field If user clicks this link: [login to view URL] find the IP number for the computer=home from same table and redirect user to this address http://IPNUmber You need to use this to connect to the db: Set oConn = [login to view URL]("[login to view URL]") [login to view URL]("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & [login to view URL]("\designit2002\db\[login to view URL]"))
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
ASP