The web does not support Access created Pages
See FP help on using Databases within FP
Create your asp page in FP, Import your DB into FP (or see below), then use the DB Wizard in FP
If your DB is on another server select it in Tools Site Settings Database
|
| Let me try this once more. I created a "RESULTS.asp" page WITHIN the same
| database (under the PAGE Tab) using the MS Access (ASP) Page Wizard (not the
| form wizard) using the table, "Results" table to point to as my database
| table backend, WITHIN the same database. Once accomplished, you can go to
| the MS Access Page tab within the same database, see, and open a form that
| opens as an ASP page from with the same database to see all the records from
| the the backend RESULTS table (under the TABLE Tab) WITHIN the same database.
| When I saved the ASP page, within my database, it also saved an,
| "Results.html" form outside my database. This does work I have made it work.
| As I have stated in previous post;
|
| My purpose, is that I want to access and display information from an Access
| back-end database table. The asp and html form and pages, along with the
| database, just happens to be on a remote website where I can track
| registrations using a shortcut on my desktop.
|
| My Problem, as I previously stated, is that every-now-and-then I get the
| following errors;
|
| Whn I tried to open the backend database table in a browser. The explorer
| Window opens with the Title on the form, but it will show no data. I then
| got the following error message:
|
| "Data Provider could not be initialized."
|
| Other times I would get the error message;
|
| “Could not find the file C:\Documents and Settings\John
| Phelan-Cummings\Local Settings\Temporary Internet
| Files\FrontPageTempDir\DownloadArea2a3.mdb."
|
| There is no directory, “\FrontPageTempDir\, and the actual location of this
| file, “DownloadArea2a3.mdb is located at, “C:\Documents and Settings\John
| Phelan-Cummings\Local Settings\Temporary Internet Files\DownloadArea2a3.mdb.
|
| The times that I would get these error messages is when I made minor
| cosmedic changes to the page and re-save them in their default locations.
|
| I said that I got it to work, but with everything breaking now and then.
| Usually, I have to start over from scratch to recreated everything.
|
| I really do not know about the terminology that I am using. I think I am
| making myself fairly clear on what I am trying to do and what the problems
| are. Also, MS should know why they wrote certain error messages the way they
| do and why they use the "terminology" they use; I find them quite vauge. I'm
| sorry that I can't be more clear on what generated my problem. I was hoping
| that someone in the news group would find some of the things, I've stated,
| familure.
|
| John
|
|
|
| "Stefan B Rusynko" wrote:
|
| > Your Terminology is misleading
| > When you say "I created an asp page WITHIN my database " that is not the same as "Creating an asp page to access your Database",
| > which is what you did
| >
| > Since no one can figure out what your problem is/was, no one can provide a useful answer
| > - unless you can explain step by step what you did that generated a problem
| >
| >
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | I have no idea what you mean by, "full html/asp page (w/ all html tags in a
| > | database record / field in your DB). I used the MS Access wizzard to create
| > | everything. The only modifications I made were minor cosmedic changes in the
| > | page layout. I can display database records in both html/asp. I even have a
| > | shortcut on my desk to the onsite html form. Every thing seems to be working
| > | now.
| > |
| > | However, everything worked once before, but eventually leading to the errors
| > | below. I cannot find any good detail documentation on what to do and what
| > | not to do. Everything is working now, but how long is it going to last, why
| > | does it get broken, and what can I do about it next time? I'm flying by the
| > | seat-of-my pants. I can't help but feel that, I'll be repeating much of the
| > | E-mail below again, in another day or two.
| > |
| > | John
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > If you have a full html / asp page (w/ all html tags in a database record / field in your DB) you can display it from the
| > database
| > | > (using another .asp page to call the DB), but it will only display / render the html in the DB field and not "parse" any ASP
| > code in
| > | > that database field
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > | I said that I created an asp page WITHIN my database located in my WEB SITE
| > | > | (and maybe outside as well); I did create a new (asp) PAGE as opposed to a
| > | > | new Form. After I was through making minor modifications, it was also saved
| > | > | as an HTML form, as one of the steps, in my WEB SITE (only, and, this time
| > | > | NOT within my database). Now matter how you cut it everything below holds.
| > | > |
| > | > | I believe it is the purpose of ASP (front-end) pages, to access and display
| > | > | information from an Access back-end database. The asp and html form and
| > | > | pages, along with the database, just happens to be on a remote websie where I
| > | > | can track registrations.
| > | > |
| > | > |
| > | > |
| > | > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > | > |
| > | > | > ASP pages are pages in web sites, not in databases. Can you explain what you
| > | > | > are trying to do?
| > | > | >
| > | > | > --
| > | > | >
| > | > | > ~ Kathleen Anderson
| > | > | > Microsoft FrontPage MVP
| > | > | > Spider Web Woman Designs
| > | > | >
http://www.spiderwebwoman.com/resources/
| > | > | >
| > | > | >
| > | > | >
| > | > | > > I created an, “asp†page within the database,
“DownloadArea2a3.mdbâ€ÂÂ
| > | > | > > which worked. It also gave me the option to save the page as an,
| > | > | > > “Registration_Results.htm†page outside of the database, (which I did
| > | > | > > one level up in my root directory/folder, "inbusiness.ws"). from the
| > | > | > > directory/folder, “fpdb†containing the database.
| > | > | > >
| > | > | > > I then located the, “Registration_Results.htm†file and tried to open
| > | > | > > it up in a browser. The explorer Window opens with the Title on the
| > | > | > > form, but it will show no data. I get the following error message:
| > | > | > >
| > | > | > > Data Provider could not be initialized.
| > | > | > >
| > | > | > >
| > | > | > > Then, when I click on, “okâ€ÂÂ, I get the following error message:
| > | > | > >
| > | > | > > “Could not find the file ‘C:\Documents and Settings\John
| > | > | > > Phelan-Cummings\Local Settings\Temporary Internet
| > | > | > > Files\FrontPageTempDir\DownloadArea2a3.mdb.
| > | > | > >
| > | > | > > There is no directory, “\FrontPageTempDir\â€ÂÂ
| > | > | > >
| > | > | > >
| > | > | > > However, the actual location of this file, “DownloadArea2a3.mdb†is
| > | > | > > located:
| > | > | > >
| > | > | > > “C:\Documents and Settings\John Phelan-Cummings\Local
| > | > | > > Settings\Temporary Internet
| > | > | > > Files\DownloadArea2a3.mdbâ€ÂÂ.
| > | > | > >
| > | > | > > John
| > | > | >
| > | > | >
| > | >
| > | >
| > | >
| >
| >
| >
