R
Ron Ehrlich
My wife and I subscribed to what seemed a fairly robust web hosting service
for a monthly fee that was less than ten USD. They are very nice in terms of
help, but I just cannot get the Microsoft Access Data Access Pages thing to
operate. When I tried contacting microsoft about a good web hosting service
for data access pages, they referred me to about 6 companies that charge a
minimum of 300 USD per month, and I dont need hundreds of email accounts,
terabytes of disk space, nor any of the other fancinesses.
At any rate, here is my problemo:
We created an mdb Microsoft Access data base for our web site
which works successfully with an ASP program that we wrote.
So then we want to use the feature of Microsoft Access called "Data
Access Pages", which is functionality that automatically creates canned htm
pages
to update a MS Access mdb data base; we have nothing to do with the
formulation of these htm entities; they get spewed out automatically.
So what we did was this:
1. from scratch, using MS Access, we created a super simple data base
containing records with only two fields: name and phone number. this
data base was called db6.mdb.
2. We then told ms access to automatically create a "data access page"
from the db6.mdb and named it "Contacts.htm".
3. We then used MS Access to change the connection string in
Contacts.htm regarding the location of db6.mdb, so that the connection
string would point to the web host location
(C:\sites\Single6\dheconsl\database\db6.mdb)
4. We then uploaded contacts.htm to our web host webroot area and
db6.mdb to our web host data base area.
5. We then used our IE6 browser under XP-SP2 to attempt to have the
contacts.htm data access page work with the db6.mdb data base and this
failed, as follows: The page displays with an error message, "Microsoft
Office Web Components could not open the data base
C:\sites\Single6\dheconsl\database\db6.mdb".
6. I also tried this on Windows 2000-SP4 using IE6.0.2800.1106 and it
fails the same way as on XP.
So what we are saying is that we do not know how to get Microsoft Data
Access Pages which are automatically created by MS Access to function on
our web site. Please allow me to make it clear that we have
nothing to do with the programming of the data access pages, so we are
not asking for help with programming as such; what we
are asking, please and thank you, is to somehow have the web host
support MS Access Data Access Pages, or any other suggestion for
success.
There seems to be one advertised catch with Data Access Pages that seems
like a feeble arrangement, but of course, we never get to test its validity
because we cant get them to work from our own browser: the catch is this: it
seems that if a developer ever got the drat things working, that any users
would need to buy some .exe file from Microsoft, and that is something we do
not have the luxury of having every user of our proposed web data base
purchase.
The fairy tale solution to this enigma would be for some genius to concoct a
program that converts MS Access forms, queries and reports, into ASP
programs; because we know for sure that ASP programs on our website can
operate with mdb databases on our web site, but the tragic deal is that we
have about a dozen mdb databases with hundreds of forms and reports that we
do not have the funds (we are non-profit) to convert to ASP.
Your reactions, please.
for a monthly fee that was less than ten USD. They are very nice in terms of
help, but I just cannot get the Microsoft Access Data Access Pages thing to
operate. When I tried contacting microsoft about a good web hosting service
for data access pages, they referred me to about 6 companies that charge a
minimum of 300 USD per month, and I dont need hundreds of email accounts,
terabytes of disk space, nor any of the other fancinesses.
At any rate, here is my problemo:
We created an mdb Microsoft Access data base for our web site
which works successfully with an ASP program that we wrote.
So then we want to use the feature of Microsoft Access called "Data
Access Pages", which is functionality that automatically creates canned htm
pages
to update a MS Access mdb data base; we have nothing to do with the
formulation of these htm entities; they get spewed out automatically.
So what we did was this:
1. from scratch, using MS Access, we created a super simple data base
containing records with only two fields: name and phone number. this
data base was called db6.mdb.
2. We then told ms access to automatically create a "data access page"
from the db6.mdb and named it "Contacts.htm".
3. We then used MS Access to change the connection string in
Contacts.htm regarding the location of db6.mdb, so that the connection
string would point to the web host location
(C:\sites\Single6\dheconsl\database\db6.mdb)
4. We then uploaded contacts.htm to our web host webroot area and
db6.mdb to our web host data base area.
5. We then used our IE6 browser under XP-SP2 to attempt to have the
contacts.htm data access page work with the db6.mdb data base and this
failed, as follows: The page displays with an error message, "Microsoft
Office Web Components could not open the data base
C:\sites\Single6\dheconsl\database\db6.mdb".
6. I also tried this on Windows 2000-SP4 using IE6.0.2800.1106 and it
fails the same way as on XP.
So what we are saying is that we do not know how to get Microsoft Data
Access Pages which are automatically created by MS Access to function on
our web site. Please allow me to make it clear that we have
nothing to do with the programming of the data access pages, so we are
not asking for help with programming as such; what we
are asking, please and thank you, is to somehow have the web host
support MS Access Data Access Pages, or any other suggestion for
success.
There seems to be one advertised catch with Data Access Pages that seems
like a feeble arrangement, but of course, we never get to test its validity
because we cant get them to work from our own browser: the catch is this: it
seems that if a developer ever got the drat things working, that any users
would need to buy some .exe file from Microsoft, and that is something we do
not have the luxury of having every user of our proposed web data base
purchase.
The fairy tale solution to this enigma would be for some genius to concoct a
program that converts MS Access forms, queries and reports, into ASP
programs; because we know for sure that ASP programs on our website can
operate with mdb databases on our web site, but the tragic deal is that we
have about a dozen mdb databases with hundreds of forms and reports that we
do not have the funds (we are non-profit) to convert to ASP.
Your reactions, please.