Unanswered: Host forms and run reports based on access 2010 database on Sharepoint 2007?
I want to build a database where users can fill out forms to add new entries and use the forms to run reports and I believe this would best be done with Access 2010 and possibly Infopath 2010. However, I need it hosted online, which is where sharepoint comes in. My company already uses it, but only the 2007 version. How would I host the forms within sharepoint that connect back to the database? Or do I need to upload my tables to sharepoint as lists and then sync those with Access?
I really have no idea how to begin and can't seem to figure out how to get my form up and running on sharepoint. Also, how should Infopath fit into all of this? Can I use it to make my forms or should I stick with Access?