needto automatically generate reminders in access database

[Devvrat Chauhan]

i have an access database on a server which i have very
limited rights to. i need to create a macro/form anything
at all which will generate reminders and send auto emails
each 48 hrs from the time field in the database. i am on
the client side and the servcer s in another country and
have very limited control on the database on the server.

 

[Steve Schapel]

Devvrat,

Is the whole system on the server, or do you have a split database with
the data itself in a "backend" file on the server, and you have the
frontend application on your local machine? When you say "very limited
rights", what are the limitations? One way, I imagine, of achieving
your purpose, would be to use Windows Task Manager, or some third party
scheduling software, to run the procedures to send out the emaills. But
you would need to write macros or some VBA code into the application...
do you have permissions and access to these design functions?