Downloading form from Website to ACCESS form

[June C]

If a form was placed on a website to be completed by visitors, who would also need to send an attachment, how can the form with the attachment be automatically downloaded into an ACCESS form/table. It is anticipated that could be quite a large number of submissions. Can anyone help please?

 

[Pat Hartman]

You are not talking about an Access form. They can't exist outside of an Access database. The web form should be storing data in some table or tables. That is where you would get the data from.

 

[boblarson]

You are not talking about an Access form. They can't exist outside of an Access database.

Unless, of course, you're using Access 2010 web forms with SharePoint 2010 with Access Services installed. (which is expensive).

 

[Pat Hartman]

But then the OP would have said he was using sharepoint

 

[June C]

Thank you. It sounds as though my son will have to delve more into how he is going to import to ACCESS the information supplied by applicants via either the website or email. I am totally out of my depth!!!!

 

[Pat Hartman]

Access can get data from whatever database the web pages use as long as the database is accessable to non-web applications. Your provider can tell you how to do that. SQL Server and MySQL are common databases for web applications.

 

[June C]

He now has everything under control and should be sorted within the next week. Up to me now to create the ACCESS tables and forms in my spare time! What we do for our children. Thank you for your help.