T
tpeter
I have created a sendobject function that opens and emails a report. The
report has been setup to only look at the current months data and populate
the report. I was trying to use the windows xp task schedualer to
automatically do this monthly for different managers in my department. After
the macro was created I drug it to another file location to create a
shortcut. The window task schedualer grabs this macro and runs it. Everything
works fine when I manaually run the macro shortcut. This database does have
user level security on it which is causing a problem. Windows wants to reopen
Access 2003 database and can't log in, so the macro is stoped. I have tried
this with both the data base open and close, when running manually the
database must be open. Any help on getting around this issue would be great.
report has been setup to only look at the current months data and populate
the report. I was trying to use the windows xp task schedualer to
automatically do this monthly for different managers in my department. After
the macro was created I drug it to another file location to create a
shortcut. The window task schedualer grabs this macro and runs it. Everything
works fine when I manaually run the macro shortcut. This database does have
user level security on it which is causing a problem. Windows wants to reopen
Access 2003 database and can't log in, so the macro is stoped. I have tried
this with both the data base open and close, when running manually the
database must be open. Any help on getting around this issue would be great.