I'm looking to create some batch jobs in MS-Access that generates a report and then sends it out to various recipients every month.
The box is running Windows Server 2003 and doesn't have MS-Access installed on it. Is MS-Access 2007 compatible with this OS? Or is there an alternative to MS-Access that I can use.
The database just sits on the HDD as a MDB file, so I could set up a ODBC connection and poll data from it through there to be generated by another program. Are there any suggestions for alternative programs in this respect?