Maybe I missed something, but isn't that what IIS abd ASP have been offering for years?Originally Posted by SoftwareMatt
Maybe I missed something, but isn't that what IIS abd ASP have been offering for years?Originally Posted by SoftwareMatt
Not sure I understand your point/question.Maybe I missed something, but isn't that what IIS abd ASP have been offering for years?
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.Originally Posted by SoftwareMatt
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 Access MVP -2010-2015
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11