Batch Reports in MS-Access

From Visual Basic to GNU C, this is the place to talk programming.

Moderators: SecretSquirrel, just brew it!

Batch Reports in MS-Access

Postposted on Tue Aug 10, 2010 8:01 am

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?
Image
Nitrodist
Grand Gerbil Poohbah
 
Posts: 3280
Joined: Wed Jul 19, 2006 12:51 am
Location: Minnesota

Re: Batch Reports in MS-Access

Postposted on Tue Aug 10, 2010 8:52 am

Sql Server Reporting Services has this built in (I assume you mean emailing the reports). I'm guessing the Express/free version has the scheduling capability too, but I've never used it. You probably could keep everything in an mdb file too. http://technet.microsoft.com/en-us/libr ... 65166.aspx
wibeasley
Gerbil Elite
Gold subscriber
 
 
Posts: 952
Joined: Sat Mar 29, 2008 2:19 pm
Location: Norman OK

Re: Batch Reports in MS-Access

Postposted on Tue Aug 10, 2010 9:23 am

Sql Server Reporting Services has this built in (I assume you mean emailing the reports). I'm guessing the Express/free version has the scheduling capability too, but I've never used it. You probably could keep everything in an mdb file too.


Unfortunately, the Express (free) version of reporting services does not support scheduled delivery of reports; and I don't believe it will connect to an .mdb file either - report data has to come from the local SQL instance.

That said, getting the data from Access to SQL is relatively easy, and there are ways to call the Reporting Services web service via an application, so you could always build an app that calls the reports on a schedule and then mails them out for you...
cphite
Gerbil Elite
 
Posts: 518
Joined: Thu Apr 29, 2010 8:28 am


Return to Developer's Den

Who is online

Users browsing this forum: No registered users and 2 guests