Article ID: 162024 - Last Review: September 26, 2001 - Revision: 1.0

XL97: Cannot Use Form on FrontPage Personal Web Server

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q162024
Expand all | Collapse all

SYMPTOMS

If you create a form by using the Microsoft Excel 97 Web Form Wizard, you may not be able to use the form or the other files that are created by the Web Form Wizard when you click "Microsoft Internet Information Server with the Internet Database Connector" in step 3 of the wizard.
Back to the top

CAUSE

This problem occurs when your Web is located on a FrontPage Personal Web Server. The FrontPage Personal Web Server does not support the Internet Database Connector interface.
Back to the top

RESOLUTION

To resolve this problem, move the files that are created by the Web Form Wizard to another Web server, such as an Internet Information Server or a Microsoft Personal Web Server. Then, rerun the Web Form Wizard so that the name of the new server is correctly entered in all the files that are created by the wizard.

NOTE: Microsoft FrontPage 97 includes both the FrontPage Personal Web Server and the Microsoft Personal Web Server.
Back to the top

MORE INFORMATION

When you click "Microsoft Internet Information Server with the Internet Database Connector" in the Web Form Wizard, four files are created. The following table lists the four files (the default names are listed) that are created. 
  File         Description
   ------------------------------------------------------------------------

   Myform.xls   Imported into your web; is the form used to collect
                data

   Myform.mdb   Data from your form is written to this Microsoft Access
                database. A System data source must be created on the
                Web server for this database.

   Myform.idc   Must be copied to the Scripts folder on the Web server;
                contains the Structured Query Language (SQL) query and
                database connection information

   Myform.htx   Must be copied into the Scripts folder on the Web server;
                contains the format for the query results
Back to the top

REFERENCES

For more information about the Web Form Wizard, click the Index tab in Microsoft Excel Help, type the following text
web form wizard
and then double-click the selected text to go to the "About setting up your data gathering system" topic.
Back to the top
APPLIES TO
  • Microsoft Excel 97 Standard Edition
  • Microsoft FrontPage 97 Standard Edition
  • Microsoft FrontPage 1.1 Standard Edition
Back to the top
Keywords: 
kbenv kbweb KB162024
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top