SOS..Cannot retrieve form database results!

[Gauthier]

help...newbie...just created a website (for ref:
www.integratedsoftwaresolutions.ca) and we're having trouble
FINDING/RETRIEVING our database results from our "service request" form...

we did the following:
- created the form
- selected send to database
- frontpage "successfully created a database"
- "added" the connection
- "verified" connection
- saved "results" as .asp
- "saved" and "published" to web
- went to I.E. and used the form
- received "confirmation"
- selected the "return to form" (default setting in "default" confirmation
form"

we now have two files located in our "fpdb" folder...one called
"results.asp", and one called "servicerequest1" mdb..
when i go into the "results.asp" file, nothing is there but our field
headings...
- am i supposed to some how manually "retrieve" the data from the website?

i went into the "servicerequest1.mdb" file and clicked on the "results"
table...again, nothing but our field headings...

this is all very NEW to me, and i have no idea how to "get" the form
results...
i am obviously missing something...

fyi...our ISP supports ASP and FTP and Frontpage Extensions...

pls help!
tks
sandi

 

[Mark Fitzpatrick]

Make sure that when you published the web that you are publishing it using
http through the File | Publish Web. You don't want to publish using FTP as
that can break the FP Server Extensions. If you did publish using FTP,
FrontPage may not have been able to set the directory permissions correcctly
on the fpdb folder. This folder needs some special permissions as the web
server needs to be able to write to it. The file that will store your
results is the mdb file, which is your access database. One thing to make
sure, and I know this is stupid but some people make this mistake, is to
make sure that the mdb file you are trying to view is the one on the server
ad not the local copy. I've seen some instances where a user publishes their
site, tests the form, and then tries to open the mdb file on their computer
instead of the web site.

Probably it's just a permissions issue and MS has several articles about
this at support.microsoft.com like the following:

http://support.microsoft.com/default.aspx?scid=kb;en-us;299342&Product=fp2002

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[Gauthier]

mark, can u elaborate on the part about accessing the .mdb file located on
the server and not the local copy...
how do i know which one i'm accessing?
i've simply been opening up my web thru frontpage, going to the fpdb folder,
and opening up the .mdb file...the "location" (shown in the properties menu)
for the .mdb file shows: "http://........" - that means its on the server
correct?

i checked the ms article which refers to setting the security/permissions...
under the users tab it shows <local>myname...
access rights show "administer, author and browse"...
the default is set to "everyone has browse access"...
i don't have control to edit any of the "user" info...
am i ok here?

sandi

 

[Gauthier]

AHHH!!! i figured it out...what i did was open up myweb on frontpage, then
selected file - open and typed my url...
there i found the results in the fpdb/mdb file!! yippee...
questions -
from now on, when i went to see the results, i have to do this? - that said,
since this is a "service request" form (and time-sensitive), i will need to
manually check this folder every 15 mins, or 1/2 hr ??
what is the purpose of the fpdb/mdb file on "myweb" (the 'local' folder?) if
that is not where i get the results from?

now that i've figured out the DB thing, i'm thinking EMAIL is the better way
to go!!

i am using fp 2000...is there any way to send to db, AND email??
sandi

 

[JDR]

Sandi,
The fpdb is a special folder that will contain all
databases you create in FP. It is advised that you leave
your databases there.

The ideal situation is to post your information to a
database and then retrieve the information through an asp
page. In FP 2002 / 03 you could use the database results
wizard to create an asp page that would populate from
your database.

You can post to a database and an e-mail address at the
same time. Download the file from this page:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;275251

In the meantime, I would probably agree with you, that it
is best to just have the form sent to you via e-mail.
This will allow you to work on the database and other
things without causing much disruption. You can test the
DB when you have everything worked out and then just link
to it.

Hope it helps
JDR
***************