This topic provides reference information about:
How your Web server processes IDC/HTX files
How your Web server processes ASP files
When you output a table, query, or form as IDC/HTX files, instead of an .html file, Microsoft Access creates an HTML extension file (.htx).and an Internet Database Connector file (.idc). Internet Database Connector (httpodbc.dll) is a component of Microsoft Internet Information Server.
The .idc file contains a query in the form of an SQL statement and information that Microsoft Internet Information Server uses to connect to an ODBC data source, in this case, either a Microsoft Access database or Microsoft SQL Server database. The connection information includes the data source name and often a user name and password, both of which are optional.
The .htx file is an HTML file that contains formatting tags and instructions, and, instead of data, placeholders indicating where to insert the values returned from the query in the .idc file.
After you publish your IDC/HTX files to a Web Server, Microsoft Internet Information Server, upon request from a Web browser, opens the database (by using the appropriate ODBC driver and the .idc file connection information), runs the query in the .idc file to access the data, merges the results and .htx file into one .html file, and then sends the dynamically created .html file to the Web browser for display as a Web page.
Return to top
When you output a table, query, or form as an ASP file, instead of an .html file, Microsoft Access creates a Microsoft Active Server Page (.asp) file. Active Server is a component of Microsoft Internet Information Server 3.0 or later.
The .asp file contains HTML tags interspersed with one or more queries in the form of SQL statements, template directives, and Visual Basic Script code containing references to ActiveX Server Controls. The .asp file also contains ODBC connection information to connect to an ODBC data source, in this case, an Access or Microsoft SQL Server database. The connection information includes the data source name, and often a user name and password, both of which are optional.
After you publish your ASP files to a Web Server, Microsoft Internet Information Server, upon request from a Web browser, runs the Visual Basic Scripting code, calls the ActiveX Server Controls, opens the database (using the appropriate ODBC driver and the .asp file connection information), runs the queries in the .asp file to access the data, merges the results and HTML tags in the .asp file into one .html file, and then sends the dynamically created .html file to the Web browser for display as a Web page.
Return to top