FP2003 problem with form feeding database

G

Guest

I have set up a form to feed an existing database. The database is in the
_private folder in the server as I have asp password protected pages as
suggested by MS.
When the database was imported the connection was set to reflect that location

.. the form and the database have matching fields
.. the database has been updated
.. the connection has been verified
.. i can fill in the form and get a confirmation page of the fields entered

....BUT the data does not appear in the database!

Have looked everywhere but to no avail. Any suggestions?
Thanks
EdH
 
T

Thomas A. Rowe

FP should have prompted you to allow it to move it to the fpdb folder.

Export the db out of the web, and delete the global.asa file, then re-import and allow FP to place
it in the fpdb folder.

You testing this on a server via http and that support ASP and Access, correct?

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
G

Guest

Hi Thomas. Thanks for response.

Well, I re-imported the database to fpdb and I get exactly the same.

I can log in and then I fill in the form to update the data and it gives me
a form confirmation...but the data is not added to the database.

I again checked the connection, the datafields, and it all seems to be in
order.

And yes, I am using an ASP server with access.

I did not use the Database Interface Wizard. Should I have?

Thanks,
EdH
 
T

Thomas A. Rowe

If you have Admin access to the server, the Application Root needs to be set for the site.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
G

Guest

The server is at a hosting service so I do not admin it. However I have used
this site before with a database fed by a form so I know it works.

Question: to write the data to the database don't I have to do a Custom
Query and add a statement like INSERT INTO, etc? Or does the wizard do it by
itself?

Thanks,
EdH
 
T

Thomas A. Rowe

If you using the database components, you would open the form in FP, then under Form options select
send to database.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
G

Guest

That is what I am doing. I choose send to database from the form priorities,
choose more options and verify that it is using the correct connection,
database and table, match the fields but...once I use the form, I get a
confirmation but the data is not entered into the database.

Don't I need an INSERT statement somewhere?

Should I be using the Databse Results Wizard anywhere?

Thanks,
Ed Healy
 
G

Guest

Yes, I deleted the global.asa file and also the _fpclass folder (just in
case). I then imported the database and made the connection.

I did use the same form as before though, should I have used a new form? I
did check all the connections and fields and all was well.

Any ideas?
Thanks,
EdH
 
G

Guest

Look what I found:

Article ID : 219158
FP2000: Submitting Form Displays Confirmation Page but Does Not Add Data to
Database

And I realize that I have a couple of fields that do not match and I just
said Cancel as I am keeping those blank for the time being! I am going to
edit those fields and get back to you.

Ed
 
G

Guest

No, that wasn't it.

As a matter of fact I made a new form with just two fields, matching exactly
the fields in the dbase and adding just those two fields to the database,
made the connection, and still the same. I get the Form Confirmation page but
no data is added to the database.

Help!
Ed
 
G

Guest

Hi Kathleen. Thanks for response.

I checked the database name, table name and field names and there are no
spaces nor special characters in them.

As a matter of fact I just tried using the Databse Interface Wizard with my
database and it worked! The submission form is not as pretty as my form but I
can edit it to my liking.

What is frustrating is not knowing what I was doing wrong when trying to set
a database entry form without using the DIW. If you have any ideas they would
be appreciated. If not, I still have a working solution.

Thanks,
Ed
 
G

Guest

I have a feeling that the fields may not have matched EXACTLY in the form and
the database. When I used the DIW with my database the form it created used
exactly the same fields as the database.

What is strange is that FP it let me save everything and even let me enter
data in the form and then gave me a confirmation, but no data was entered -
go figure!

Thanks again,
EdH
 
T

Thomas A. Rowe

You would have to show us your handwritten code for anyone to see what you were doing wrong.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 

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

Similar Threads

Linking a Form to an Access Database 4
Access Database Form Submission problems in FP2003 3
File upload and database FP2003 2
FP2003 - Receiving confirmation pages but database not updating 2
Data not going into database 1
Database Interface Wizard: remove unwanted fields 6
Limitation in Number of Fields ... 1
Adding records to a Access database through frontpage 15

Top