I just started working for a company that has several Access databases - A total of 7 gigabytes of Access files that are linked to raw data files. The raw data files come from different departments and must be run through Access queries to format them correctly. There are also links between the Access databases, and it gets very confusing.
My boss wants me to improve the system and include on-line reporting for about 50 internal people. He would like for the reports to be interactive with dropdowns and radio buttons. I am an expert VBA programmer for Excel, and could build this type of report without a problem, but have no clue how to get this on a website. I am willing to learn a new reporting software, if it would work better on-line and more seamlessly with a database. Perhaps Access Data Pages or SQL Reporting might be better.
What backend database do you recommend, and what do you recommend for the on-line reporting?
I'm a lazy bum, not willing to do more work than necessary to get the results that I need. Especially for this size job, I'd suggest SQL Server 2000, with SQL Server 2000 Reporting Services. Quick and easy to code, basic funcionality is almost automatic, with nearly unlimited customizability. Best of all, it is easy to exchange documents between SQL Server, Excel, Access, DBF, flat-files, and just about anything else that does either OLE or ODBC.