T
Thomas Robb
Yesterday, I posted the message below:
*I have two web pages with separate forms that both dump
into one Access database (two separate tables). The
forms have worked consistently for the past 6 months or
so. Within the past few weeks, for some unknown reason,
they stopped working.
The confirmation page appears when you hit submit, but
the data does not show up in Access. I went to "Form
Properties" and checked the database connection, looked
at each form field and ensured they were mapped to the
correct location in Access, and clicked save. With
subsequent testing, I was unsuccessful.
I went onto the Adminstration Home Page (Tools->server-
Anonymous Access is turned OFF. Users have to put a user
name and password in that is common to all users
(assigned to the contributor role). I tried
Recalculating the Web to see if that would work. No
success as of yet.
On the "Version Control", what should those settings be?
Should I use built in or none? What is "Source Control"
and do I need this turned on. Currently, it is set
at "None" and I didn't change it. Doesn't mean our IT
department didn't do so, but let me know.
Is there anything else I can check without having to
recreate both forms? Is there some settings on the
Server that need to be in place. Microsoft Server
Extensions are installed on the server and I am using FP
2002.
Your anticipated help is appreciated.*
Your reply on 8/9/2004 was this
*Diagnosing Errors Saving a Form to a Database
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=35
Jim Buyens Microsoft FrontPage MVP
http://www.interlacken.com Author*
This did not give me any errors when I put an apostrophe
in column 1 and viewed the page with the http://URL. I
removed the apostrophe and saved it. The form data will
go into the Access database if I do the form on my
computer, but will not do so on another users computer.
I have tested it with 5 different machines and the only
one that works is if I access the web page off my machine.
HELP!
Earlier today you responded with this message
Was the server recently upgrade to Windows 2003 or have
you upgraded to FrontPage 2003?
You don't need to have Source Control enable unless you
have more than one developer working on the
site content and want to enable the checking In/Out of
pages.
I replied with this message
No, we did not recently upgrade to Windows 2003 or FP
2003. I am using FP 2002.
You replied with this message
Subject: Re: Form Data and Access
From: "Thomas A. Rowe" <[email protected]> Sent:
8/10/2004 12:37:33 PM
Ok, then for each web, etc. open in FP, then Tools | Web
Settings | Database, delete and recreate
each connection.
My newest reply
I did this and still no luck ONLY from other users
computers besides my own.
*I have two web pages with separate forms that both dump
into one Access database (two separate tables). The
forms have worked consistently for the past 6 months or
so. Within the past few weeks, for some unknown reason,
they stopped working.
The confirmation page appears when you hit submit, but
the data does not show up in Access. I went to "Form
Properties" and checked the database connection, looked
at each form field and ensured they were mapped to the
correct location in Access, and clicked save. With
subsequent testing, I was unsuccessful.
I went onto the Adminstration Home Page (Tools->server-
have had them for the past 6 months and they are.Administration Home) to ensure the settings were how I
Anonymous Access is turned OFF. Users have to put a user
name and password in that is common to all users
(assigned to the contributor role). I tried
Recalculating the Web to see if that would work. No
success as of yet.
On the "Version Control", what should those settings be?
Should I use built in or none? What is "Source Control"
and do I need this turned on. Currently, it is set
at "None" and I didn't change it. Doesn't mean our IT
department didn't do so, but let me know.
Is there anything else I can check without having to
recreate both forms? Is there some settings on the
Server that need to be in place. Microsoft Server
Extensions are installed on the server and I am using FP
2002.
Your anticipated help is appreciated.*
Your reply on 8/9/2004 was this
*Diagnosing Errors Saving a Form to a Database
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=35
Jim Buyens Microsoft FrontPage MVP
http://www.interlacken.com Author*
This did not give me any errors when I put an apostrophe
in column 1 and viewed the page with the http://URL. I
removed the apostrophe and saved it. The form data will
go into the Access database if I do the form on my
computer, but will not do so on another users computer.
I have tested it with 5 different machines and the only
one that works is if I access the web page off my machine.
HELP!
Earlier today you responded with this message
Was the server recently upgrade to Windows 2003 or have
you upgraded to FrontPage 2003?
You don't need to have Source Control enable unless you
have more than one developer working on the
site content and want to enable the checking In/Out of
pages.
I replied with this message
No, we did not recently upgrade to Windows 2003 or FP
2003. I am using FP 2002.
You replied with this message
Subject: Re: Form Data and Access
From: "Thomas A. Rowe" <[email protected]> Sent:
8/10/2004 12:37:33 PM
Ok, then for each web, etc. open in FP, then Tools | Web
Settings | Database, delete and recreate
each connection.
My newest reply
I did this and still no luck ONLY from other users
computers besides my own.