Update a table on the server side

[MrMajik]

On an In/Out board using Access 2002:

I have a form that is linked to a couple tables on our network. Is it possible to have some code run on the server side database at 12:05 AM that will compare dates? If a date in the table is yesterday's date I want the date deleted.

I considered having this done on the desktop side (front end) In/Out board form but it is possible that everyone will close their In/Out board and turn off their computers at the end of the work day, thus the dates would not be updated.

Thank you,

MrMajik

There are 10 types of people in the world:
Those that understand binary and those that don't.

 

[PHV]

You may consider the server's windows task scheduler launching your access DB with the /X command line option.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886