I have a Sharepoint 2010 site and using MS Access 2007. I have an Access report that is generated by joining several Access table queries. I would like to keep all data entry and any editing through Access and use Sharepoint as a place to view the data from the Access tables. I would also like all report viewing in Sharepoint to be live views from the Access tables or reports.
To clarify, I am looking for a way to view Access reports in Sharepoint live. When data changes in Access and therefore the reports, from queries, I would like Sharepoint to show the most current and stay updated as the Access databases or reports change. I am not looking for a way to modify database tables through Sharepoint, just view the reports.