Microsoft KB Archive/192933

= Access Denied Error With IDC Files Created Using FrontPage =

Article ID: 192933

Article Last Modified on 12/1/2000

-

APPLIES TO


 * Microsoft FrontPage 98 Standard Edition

-



This article was previously published under Q192933



SYMPTOMS
When you create an Internet Database Connector (IDC) file in FrontPage 98, use the IDC Wizard to add your query, and then run the query in conjunction with the HyperText Extension (HTX) file, you receive the following error:

[Access Denied]



CAUSE
This message appears when FrontPage parses the data and switches the Template line with the SQLStatement line.

For example, a normal IDC file looks like this:

Datasource:Volcano

Template: something.htx

SQLStatement: Select * From Tablename

After parsing the data, the IDC file may look like this:

Datasource:Volcano

SQLStatement: Select * From Tablename

Template: something.htx



RESOLUTION
To fix your IDC file, follow these steps in FrontPage Explorer:  Right-click the IDC file. Click Open With. Double-click Notepad.exe (text editor). Move the Template line above the SQLStatement line so that your data looks like this:

Datasource:Volcano Template: something.htx SQLStateMent: Select * From Tablename

 On the File menu, click save.

(Either describes the workaround, indicates the path name, or list the revision number of the product that resolves the issues.)

<div class="moreinformation_section">

MORE INFORMATION
For additional information about database connectivity with Active Server Pages (ASP) or IDC/HTX, please see the following articles in the Microsoft Knowledge Base:

155255 IDC Queries to Access Fail from IIS 2.0

160810 FP: IDC Wizard Creates IDC File on Non-IDC Server

174407 FP98: How to Create IDC/HTX Files in FrontPage 98

Additional query words: idc pws htx database 1.0 bug front page

Keywords: kbprb KB192933

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.