Any good way to publish Access forms to the web to collect data to add to the DB?
I want to gather data from various people who won't necessarily have Access installed on their computers. I know you can publish tables to Sharepoint as "lists", but I don't see any way to get user input to add to the tables.
Would it be plausible to do it via simple HTML forms, then use PHP to pass that data through to an SQL script to write to the database? Is this overkill? I'm surprised I haven't found a better way, and I'd rather not reinvent the wheel here.