469,623 Members | 1,683 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Save Form Data to Access DB

35
Hi

I have a problem with saving form data to a MS Access database. I am using Windows XP, FrontPage 2003, Access 2003, IIS 5.1 and FrontPage Server Extensions.

I have followed several tutorials I found online, created a simple form and changed its properties so that when the data is submitted it is saved into the database. When I click on the submit button , I get a confirmation page but nothing is written in the database. I have tried this with both automatically generated FrontPage database and with an existing database but nothing is saved.

I am doing all of this locally by publishing my website to the "wwwroot" folder. I have searched google but got nothing.

I am a beginner in IIS and FP extensions, is there specific settings that I have to use after installing them ??

Please Help

Thanks in Advance ..
Jun 1 '08 #1
5 4460
idsanjeev
241 100+
Hi MeeMee
aren't getting any error ?
Can you attached your code
thanks
Jun 2 '08 #2
MeeMee
35
Hi MeeMee
aren't getting any error ?
Can you attached your code
thanks
Hi,

No I get no error, anyway it finally worked after I changed the permission to the wwwroot folder by going to Properties > Security.

I have another question, the intranet website has not asp code at all, it is all html, so it is not in the wwwroot folder. I am not that experienced with servers, now I know that IIS and FP extensions must be installed on the server so that the form works , just like I did locally. I guess that on the server I should publish the forms to the wwwroot folder again, however will I face problems if I put a hyperlink to the form (which is the wwwroot folder) on the homepage of the intarnet site ?? and what should the link be ?? Locally I access the form using localhost\form.asp

sorry for the long story :)
Jun 3 '08 #3
DrBunchman
979 Expert 512MB
Hi MeeMee,

If the intranet is located on the same server as the website then the link should be:
Expand|Select|Wrap|Line Numbers
  1.  
  2. <a href="http://localhost/form.asp">Hello World!</a>
  3.  
If the intranet is loocated on a different server then it will be:
Expand|Select|Wrap|Line Numbers
  1.  
  2. <a href="http://server/form.asp">Hello World!</a>
  3.  
Where server is the machine name or IP address where your website is located. You may experience problems depending on the security you have set on your website but give it a go and see how you get on.

Do you have any experience using the IIS console to configure your deployed websites?

Dr B
Jun 3 '08 #4
MeeMee
35
Thanks alot for your help, I will give it a try ..

I installed it IIS locally so I can work with forms, and till now I didn't need to configure anything in its console, I am trying to read as much as I can about the deployment process, I found this

http://support.microsoft.com/kb/299868

It seems simple, but I am not sure if this is all that I need .. I'd appreciate your advice.

Thanks alot
Jun 4 '08 #5
DrBunchman
979 Expert 512MB
That seems like a pretty good guide to get you started. For the time being you can deploy your website in the wwwroot folder and access it through the default website as it describes.

I suggest you go ahead and follow it and come back to us if you have any questions or come across any problems.

Good luck,

Dr B
Jun 4 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Andras Gilicz | last post: by
1 post views Thread by Mohsin | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.