L
LaRue05
To everyone who cares to help.....it's long but accurate.
I've been working with FP2003 for the past week and have a pretty good hang
of things. My main task is to create a FP Access DB to store info from a
form. Now let me tell you I have tried every last thing from several
different forums to get the submission form to post to the database that is
created with the standard DIW.
So here are the specific step by step instructions that I just did upon
uninstalling IIS and FP2003 the reinstalling IIS first and FP2003 second. I
hope that you can help me in some way. I will try all reasonable
instructions for fixing my problem.
1) Open IIS folder view >> Web Sites >> Default Web Sites.
2) Right click Default Web Sites and go to properties.
3) Go to Home Directory tab and set home directory to C:\Inetpub\wwwroot
4) Save and Close properties.
5) Open IE and connect to localhost to get IIS up and running
6) Open FP and start a new Database Interface Wizard.
6A) Specify the location of new website to C:\Inetpub\NewTest2
6B) Select ASP pages and "create a new Microsoft Access database
with in your web site" click ok.
6C) Enter name for database as "newdatabase" click ok
6D) Leave the default form fields as is. click ok
6E) Leave the default fields for files and results as is. click ok
6F) Select Result/Submission/Database Editor pages to be created.
click ok
6G) Don't protect my submission page, (not until I get this
working at least) click ok
6H) Click Finish and let DIW create pages.
So far so good I hope. I haven't done anything out of the ordinary here.
Seeing as how I left almost all the defaults I don't think I made any errors.
So here's what I do next.
7) Go to submission_form.asp in FP
8) Right click and go to form properties
8A) Select send to database radial and then click on options
8B) under tab "Database Results" select "newdatabase"
8C) Click Add Connection
8D) select "newdatabase" and click verify make sure you get a
green check mark where the question mark was located.
8E) click ok and exit back out to the "options for saving
results to database"
8F) make sure that the field "table to hold from results" has
"Results" selected
8G) click ok and exit out of form properties
9) In the Folder List view open up folder "fpdb"
10) Double click newdatabase.mdb and let it open in Access
11) Verify that the database is there and that the results table has fields
and is blank.
12) Close the newdatabase.mdb file and minimize FP and Access
Here's another break. Have I pointed everything correctly? I believe that
I have, but that doesn't mean this isn't where my error is coming from.
13) Open up the "Default Web Sites" again and go back to properties>>Home
Directory Tab
14) Set local path to C:\Inetpub\NewTest2
15) Make sure the read and write boxes are checked.
16) Go to the Directory Security tab and click edit under "Anonymous access
and authentication control"
17) Make sure the Anonymous access box is checked.
17A) Make sure "Allow IIS to control password" is checked.
Click ok to go back to properties
18) Click apply to enable properties.
19) Click ok and exit Default Web Site properties.
20) Open IE and return to localhost. The Database Interface page appears.
21) Click the "Submission Form" link.
22) Enter in some details and click "ok"
23) The next thing that happens is the Form Conformation Page.
Simple enough, everything has been pointed and no errors have popped up at
all. Cool looks like its working great.
24) So know I'll go check the Results page.
NO RECORDS RETURNED!!!!! And the same goes for the Database Editor page too.
I never get any errors at all. So here's what I do next
25) Open up Access and look at newdatabase.mdb
Wow there are no records returned odd. Ok so now I'll try something else.
26) Inside Access open up the Table "Results" inside newdatabase.mdb
27) Physically add info into the fields of name, address, and choice.
28) Save the Table.
29) Close the database. Because I've noticed that if the database is open
the web will not show the fields.
30) Open IE again and go to localhost once more.
31) Return to the results page and hit the refresh button on my browser.
Viola the Database does exist and the results page does work. So why does
the Submission form not post the information to the Database???
I'm stuck and herein lies my problem that I'm having. Any and all help
would greatly be appreciated.
Thank you very much,
Mike LaRue Rodriguez
Accelerated Computer Professionals
(979)-575-9871
(e-mail address removed)
I've been working with FP2003 for the past week and have a pretty good hang
of things. My main task is to create a FP Access DB to store info from a
form. Now let me tell you I have tried every last thing from several
different forums to get the submission form to post to the database that is
created with the standard DIW.
So here are the specific step by step instructions that I just did upon
uninstalling IIS and FP2003 the reinstalling IIS first and FP2003 second. I
hope that you can help me in some way. I will try all reasonable
instructions for fixing my problem.
1) Open IIS folder view >> Web Sites >> Default Web Sites.
2) Right click Default Web Sites and go to properties.
3) Go to Home Directory tab and set home directory to C:\Inetpub\wwwroot
4) Save and Close properties.
5) Open IE and connect to localhost to get IIS up and running
6) Open FP and start a new Database Interface Wizard.
6A) Specify the location of new website to C:\Inetpub\NewTest2
6B) Select ASP pages and "create a new Microsoft Access database
with in your web site" click ok.
6C) Enter name for database as "newdatabase" click ok
6D) Leave the default form fields as is. click ok
6E) Leave the default fields for files and results as is. click ok
6F) Select Result/Submission/Database Editor pages to be created.
click ok
6G) Don't protect my submission page, (not until I get this
working at least) click ok
6H) Click Finish and let DIW create pages.
So far so good I hope. I haven't done anything out of the ordinary here.
Seeing as how I left almost all the defaults I don't think I made any errors.
So here's what I do next.
7) Go to submission_form.asp in FP
8) Right click and go to form properties
8A) Select send to database radial and then click on options
8B) under tab "Database Results" select "newdatabase"
8C) Click Add Connection
8D) select "newdatabase" and click verify make sure you get a
green check mark where the question mark was located.
8E) click ok and exit back out to the "options for saving
results to database"
8F) make sure that the field "table to hold from results" has
"Results" selected
8G) click ok and exit out of form properties
9) In the Folder List view open up folder "fpdb"
10) Double click newdatabase.mdb and let it open in Access
11) Verify that the database is there and that the results table has fields
and is blank.
12) Close the newdatabase.mdb file and minimize FP and Access
Here's another break. Have I pointed everything correctly? I believe that
I have, but that doesn't mean this isn't where my error is coming from.
13) Open up the "Default Web Sites" again and go back to properties>>Home
Directory Tab
14) Set local path to C:\Inetpub\NewTest2
15) Make sure the read and write boxes are checked.
16) Go to the Directory Security tab and click edit under "Anonymous access
and authentication control"
17) Make sure the Anonymous access box is checked.
17A) Make sure "Allow IIS to control password" is checked.
Click ok to go back to properties
18) Click apply to enable properties.
19) Click ok and exit Default Web Site properties.
20) Open IE and return to localhost. The Database Interface page appears.
21) Click the "Submission Form" link.
22) Enter in some details and click "ok"
23) The next thing that happens is the Form Conformation Page.
Simple enough, everything has been pointed and no errors have popped up at
all. Cool looks like its working great.
24) So know I'll go check the Results page.
NO RECORDS RETURNED!!!!! And the same goes for the Database Editor page too.
I never get any errors at all. So here's what I do next
25) Open up Access and look at newdatabase.mdb
Wow there are no records returned odd. Ok so now I'll try something else.
26) Inside Access open up the Table "Results" inside newdatabase.mdb
27) Physically add info into the fields of name, address, and choice.
28) Save the Table.
29) Close the database. Because I've noticed that if the database is open
the web will not show the fields.
30) Open IE again and go to localhost once more.
31) Return to the results page and hit the refresh button on my browser.
Viola the Database does exist and the results page does work. So why does
the Submission form not post the information to the Database???
I'm stuck and herein lies my problem that I'm having. Any and all help
would greatly be appreciated.
Thank you very much,
Mike LaRue Rodriguez
Accelerated Computer Professionals
(979)-575-9871
(e-mail address removed)