Form to database

G

Guest

I have created a form and used FP to create the database connection. Once i
submit the form the confirmation page is presented but there is no data in
access when i preview. Any ideas.
 
G

Guest

Please browse:

Diagnosing Errors Saving a Form to a Database
http://www.interlacken.com/winnt/tips/tipshow.aspx?tip=35

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
G

Guest

I have performed the steps but there are no errors present. What is
necessary to transport the data from the form to the database?
 
G

Guest

Are you running on a Microsoft Web server?

Does your page have an .asp filename extension?

If you right-click the form and choose Properties, is Send To Database
selected?

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
G

Guest

Yes it is a MS Web Server running windows 2003, the form has a .asp
extension, and the properties are set to send to database. Frontpage setup
the database via the wizard. I think it is the front page server extensions
because i cannot get a hit counter to work as well as form to database
submission. I have reinstalled the extensions and extended them and it
presents that everything is successful. Any ideas, I am not sure where to
start or what to troubleshoot. I believe if the hit counter problem can be
resolved the form submission would also be successful.
 
G

Guest

Make sure that the IIS appilication that corresponds to to your FrontPage Web
site has Execute Scripts authority. This is something you configure in IIS
Manager, in the Property page for your site's or subsite's starting folder.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------
 
G

Guest

I found out today that I needed my server provider for the website to make my
database writable. Now it works.
 

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
Email 1
connect to SQL 1
FP 2003 won't use correct confirmation page 2
Feedback forms 4
form confirmation page 4
Confirmation form appears, no info is written to the database ,id field increment 3
Form -- Submit button does not invoke confirmation page. 4

Top