Apache cfg'ing to properly display MS Access Page's
Hi,
I know this isn''t necessarily the most appropriate place to ask such a question, it being not related to programming and all, but I don''t really know where else to turn.
I have Apache (v. 2.0.43 for Win32) up and running and it works just fine. When trying to open a webpage created in MS Access (heavily xml-scriped), however, it only returns a blank page (when accessed through IE locally). What do I need to do on either side (Access and Apache) to get the thing display the page properly?
http://crispy.dynserv.net
Trying to open ViewLink.htm is an exemplary example (it may display the source as well when accessed from outside my computer). The file displays correctly if I open it in my computer directly...
Thanks for your time,
Crispy
"Literally, it means that Bob is everything you can think of, but not dead; i.e., Bob is a purple-spotted, yellow-striped bumblebee/dragon/pterodactyl hybrid with a voracious addiction to Twix candy bars, but not dead."- kSquared
Couldn''t access your page (either Apache is not running or it is not configured correctly. Your computer is ignoring HTTP connections).
It sounds like you are opening the file locally (the address bar says something like C:\ or file://). If these Access pages are supposed to be scripted (note that I''ve never used Access to generate pages, so they might not for some strange reason) you need Apache to serve them, which will only happen if you access them from the "outside" (address bar should be http://127.0.0.1/...). You also need to be sure that Apache is setup to recognize the pages as scripted content (and have scripting permissions, etc, etc). If you see source code when accessing them then something is wrong (IE should not recieve any source code from the Apache server, just the output from the script).
It sounds like you are opening the file locally (the address bar says something like C:\ or file://). If these Access pages are supposed to be scripted (note that I''ve never used Access to generate pages, so they might not for some strange reason) you need Apache to serve them, which will only happen if you access them from the "outside" (address bar should be http://127.0.0.1/...). You also need to be sure that Apache is setup to recognize the pages as scripted content (and have scripting permissions, etc, etc). If you see source code when accessing them then something is wrong (IE should not recieve any source code from the Apache server, just the output from the script).
Yeah - it''s possible the server was down when you tried - I was messing around with the config and installing PHP properly. My apologies. Took me quite a while to understand that a complete outsider can''t really figure out how to run the SAPI version properly so I finally resorted to regular CGI. It appears an Access database needs PHP (just like any other database - mind you that this is the first time I''ve tried to set up a http server, let alone one with database support so I was kinda hoping for a one-push solution
. Speaking of MS - this time I was really looking forward to yet another wizard...). Anyway - I got PHP+Apache working and I kinda figured something you said, myself. Nonetheless, I don''t really know how to make PHP recognize the database. I followed some instructions telling me to choose a new ODBC under ControlPanel->AdimistrativeTools->SystemDSN, but from there on it got pretty vague.
Which address bar do you have in mind? The best I can come up with in Access is something like this for each Page:
URL: accdp://12134804/
The html file itself refers to the database as "D:\dir\file.mbd". This should be correct, right?
Crispy
![](wink.gif)
Which address bar do you have in mind? The best I can come up with in Access is something like this for each Page:
URL: accdp://12134804/
The html file itself refers to the database as "D:\dir\file.mbd". This should be correct, right?
Crispy
"Literally, it means that Bob is everything you can think of, but not dead; i.e., Bob is a purple-spotted, yellow-striped bumblebee/dragon/pterodactyl hybrid with a voracious addiction to Twix candy bars, but not dead."- kSquared
This topic is closed to new replies.
Advertisement
Popular Topics
Advertisement
Recommended Tutorials
Advertisement