Is it possible to automate data entries from a website into a ms access form?

**wedd** · 03-22-2012, 01:45 PM

Hi experts, I would like users to enter data on a from on a website, and the data entered would automatically populate fields on a form with identical field names in Access. Is this possible to do, if so how can this be done? Would you have any sample code or websites that have sample API code to do this?

Thanks for your contributions

**SoftwareMatt** · 04-04-2012, 02:37 AM

If the database was on the same server as the webpages then this would be possible but then you would need some kind of remote login to be able to use the database.

I've heard the new version of Access (possibley released later this year) is going to solve this problem. But we will have to wait and see...

**stanl** · 04-04-2012, 02:58 AM

Quote:

Originally Posted by: SoftwareMatt


	If the database was on the same server as the webpages then this would be possible

Maybe I missed something, but isn't that what IIS abd ASP have been offering for years?

**SoftwareMatt** · 04-04-2012, 03:03 AM

Quote:


	Maybe I missed something, but isn't that what IIS abd ASP have been offering for years?

Not sure I understand your point/question.

Yes IIS and asp work together and will be used on the webserver but if you want to pass the data from the webform to the database then the database will need to reside on the same server that's all I'm saying.

**stanl** · 04-04-2012, 02:06 PM

Quote:

Originally Posted by: SoftwareMatt


	Not sure I understand your point/question. Yes IIS and asp work together and will be used on the webserver but if you want to pass the data from the webform to the database then the database will need to reside on the same server that's all I'm saying.

Right, and I thought the OP indicated they would reside the same.

**HiTechCoach** · 04-24-2012, 03:32 PM

Here is another option. I use a remote web site that have a SQL server (mySQL, Microsoft SQL Server, Oracle, etc.) as the back end. The remote webs site can use ASP/, ASP.net, PHP or your favorite scripting language to store data in the SQL Server.

The remote SQL server is set up for remote connections. From the Access application on the users desktop they can import the data from the remote SQL server into their Access application.

The key is being able to make an ODBC connection to the remote SQL server. This allows you to directly extra the data.

03-22-2012, 01:45 PM	#1
wedd VBAX Regular Joined: Aug 2010 Posts: 457 Kb Entries: 0 Articles: 0	Is it possible to automate data entries from a website into a ms access form? Hi experts, I would like users to enter data on a from on a website, and the data entered would automatically populate fields on a form with identical field names in Access. Is this possible to do, if so how can this be done? Would you have any sample code or websites that have sample API code to do this? Thanks for your contributions
Local Time: 06:17 AM Local Date: 05-25-2013 Location:

04-04-2012, 02:37 AM	#2
SoftwareMatt VBAX Regular Joined: Jun 2009 Posts: 50 Kb Entries: 0 Articles: 0	If the database was on the same server as the webpages then this would be possible but then you would need some kind of remote login to be able to use the database. I've heard the new version of Access (possibley released later this year) is going to solve this problem. But we will have to wait and see... Regards JD ------------------------------------ Bespoke Access Database Design VBA Programmers
Local Time: 03:17 PM Local Date: 05-25-2013 Location:

04-24-2012, 03:32 PM	#6
HiTechCoach VBAX Regular Joined: Jul 2010 Posts: 293 Kb Entries: 0 Articles: 0	Here is another option. I use a remote web site that have a SQL server (mySQL, Microsoft SQL Server, Oracle, etc.) as the back end. The remote webs site can use ASP/, ASP.net, PHP or your favorite scripting language to store data in the SQL Server. The remote SQL server is set up for remote connections. From the Access application on the users desktop they can import the data from the remote SQL server into their Access application. The key is being able to make an ODBC connection to the remote SQL server. This allows you to directly extra the data. Boyd Trimmell aka HiTechCoach Microsoft MVP - Access Expert Programming: Nine different ways to do it right, a thousand ways to do it wrong. Binary--it's as easy as 1-10-11
Local Time: 09:17 AM Local Date: 05-25-2013 Location: