I'm not sure if this will help, but you should be able to put some button on your form that could trigger an ASP page to write the form data directly into a database table.
I spent about a week just trying to open access to a specific record via email and was never successful. I'm still certain it was just an html syntax thing, but you'd probably have a lot better luck with ASP.
My host doesn't support ASP... But I was thinking my form might be able to add an entry to a MySQL table. Then, if I could figure out how to get MS Access to connect to the MySQL db and pull the new entries then append them to my RFQ table - I'd be all set.
The other possibility might be a delimited text file.