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.)
Additional query words: idc pws htx database 1.0 bug front page
Keywords: kbprb KB192933