Form Data in Access

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-
Administration Home) to ensure the settings were how I
have had them for the past 6 months and they are.
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!
 
T

Thomas A. Rowe

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.


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top