I need to run a access macro on a daily basis and would like to automate the procees, I mean that it should run automatically at a particular point of time. Any ideas on how to accomplish it. I also like to supress the alert messages that pops up when a data manupulation occurs, these alerts should be suppresed only when the macro is run in automated mode????
Operating system : Windows 95/XP
Novell client installed version???
Microsoft Access 97
Where can I download Acess 97 runtime or how do I create the runtime using ODI?