Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying HTX/IDC MS Access 97 files

Status
Not open for further replies.

cybercop23

IS-IT--Management
Aug 12, 2001
103
US
Hello all.
First of all, if this is the wrong place to ask this question please let me know.

I have an Access 97 DB and created a query that searches one of the tables. The query has a prompt on one of the fileds. I use the Save HTML feature to publish it on my IIS server on a Win2k machine. I get the .html .htx .idc files.
I place them in on my web server.

When I try to submit the query I get the following.

Datasource:Temp
Template:WebTemp_1.htx
SQLStatement:SELECT TempORDSize.Str, TempORDSize.[0to10], TempORDSize.[10to15], TempORDSize.[15to20], TempORDSize.[20to50]
+FROM TempORDSize
+WHERE (((TempORDSize.Str)=%[Enter Store]%));

Password:
Username:

This just happens to be my .IDC file contents.

What's worng? Why am I not getting the date from my database? I checked the ODBC and it seems allright.
I checked the permistion on that directory and that seemed fine too.

Any help or guide in the right direction would be much appreciated.

Thanks all.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top