TIme Process in db with out opening db

[JONBOY74]

Hi

I have an Access db that is fed by data from a number of Excel forms in turn we then periodically feed this data into an Oracle db using a front-end in the Access db. Once this has occurred I want a tbl within Access to be updated with confirmation code which comes from the Oracle db.

The confirmation code will not be produced until the information has been confirmed within the Oracle db. This means that there is a timing issue.

I want to use a timer event that updates the Access tbl every minute, but I want this to be kicked off in the morning by the first user that logs on...... AND this is my problem

If I put the timer event on the front-end that loads the data into the Oracle db then, when more users open the Front-end the event will be kicked off time & time again

What I want is it to be kicked of once and stay active all day even if that users logs off

I really need help with this

Thanks

Jon

 

[jgoodman00]

Do you have a date field in the table which records the confirmation codes?

If this is the case, then as part of a startup sequence, open a static recordset, based upon the date. If the recordset is > 0 then it means the process has already occured & you can skip running it again.

James Goodman