This should be simple

I am looking for a module that will pay employees within an employee database on a set schedule from the server with no human interaction. Database is written in access and already exists. System needs to automatically submit forms (that are generated by the database) to a remote web site/payment gateway and set an entry in the database indicating that the employee has been paid for each record. The current gateway system we are going with for this project is standard reserve.

Current database setup:

Users: Emp_id: text
Emp_name: text
Standard_Reserve_Number: number

Payouts:
Emp_id: text
Emp_amount: number
Pay_status: text
The emp_id field is based on the employee&'s ip number. It is the unique identifier for every user of the system. There is another table called employees, which will contain the employee&'s user number, name, and standard reserve number. The application will need to look up the corresponding information for every user and submit payment to standard reserve from a central company account.

Here is the general type of interface code
That needs to be generated and submitted on the server side:

<form action=https://standardreserve.com/acct/confirm.asp method=”post”>
<input type=”hidden” name=”ACCOUNTID” value=”12345”>
<input type=”hidden” name=”PASSPHRASE” value=”something”>
<input type=”hidden” name=”PAYEE_ACCOUNT” value=”54321”>
<input type=”hidden” name=”AMOUNT” value=”100”>
<input type=”hidden” name=”PAY_IN” value=”1”>
<input type=”hidden” name=”MEMO” value=”Pay $100 to Lori”>
<input type=”hidden” name=”PAYMENT_ID” value=”24242”>
</form>

The real trick is setting it up in such a way that it is triggered by the system clock at timed intervals. This project is ideal for anyone with an in-depth knowledge of remote scripting and triggers using ansi sql.