×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Problem writing Form results to Access DB

Problem writing Form results to Access DB

Problem writing Form results to Access DB

(OP)
I have a main Domain & Site "sejasedentariocomsaude.com" with  subdomains: "curesuacoluna.com", etc.
In "index.asp" page of both sites I have a FORM that must write its results to the same Access DB: contactos.mdb, located in the special sub-directory "fpdb".

The problem is: the main one works correctly BUT the other never writes its data to the DB, but I can't see no error.

The only difference in both forms is the DB's address and related files.

I already lost a lot of time trying to solve the problem, without success but I'm not a professional in this field.

Could you help me ? You can see the code accessing my pages in the respective sites.

RE: Problem writing Form results to Access DB

(OP)
As the code accessed directly in my pages is not complete, I add it here:
1) sejasedentariocomsaude.com/index.asp » FORM:

***********************************************************
<TABLE class=verdanasmall cellSpacing=0
                              cellPadding=2 width="100%" align=center
                                border=0>
                                
                                <form method="POST" name="saiba mais" action="index.asp" webbot-action="--WEBBOT-SELF--">
  <!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="ConectDB"
  S-RecordSource="TbContatos" U-Database-URL="fpdb/contatos.mdb" U-Confirmation-Url="cadastro.asp"
  S-Form-Fields="nome email pais site" S-Form-DBFields="Nome Email Pais Site" startspan
  U-ASP-Include-Url="_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan i-checksum="40548" -->                                  
                                      <P>
                                <TBODY>
                                <TR>
                                <TD class=verdanasmall id=padrao vAlign=center
                                width="25%">Nome:</TD>
                                <TD><INPUT TYPE=TEXT NAME="nome" SIZE=12>
                                      </TD></TR>
                                      
                                <TR>
                                <TD class=verdanasmall id=padrao vAlign=center
                                width="25%"><NOBR>E-mail:</NOBR></TD>
                                <TD><INPUT TYPE=TEXT NAME="email" SIZE=12>
                                      </TD></TR>                                      
                                      
                                <TR>
                                <TD class=verdanasmall id=padrao vAlign=center
                                width="25%">País:</TD>
                                <TD><INPUT TYPE=TEXT NAME="pais" SIZE=12>
                                      </TD></TR>
                                      
                                      <input TYPE="hidden" NAME="site" VALUE="SSCS">
                                
                                <TR>
                                <TD class=verdanasmall id=padrao vAlign=center Colspan=2 align="center"><BR>
                                <INPUT TYPE=SUBMIT STYLE="Cursor: hand" VALUE="Clique já, é gratuito"></TD></TR>
                                
                                </FORM></TBODY></TABLE>

***********************************************************
2) curesuacoluna.com/index.asp » FORM:

<table align=center width="144">
     
<form method="POST" name="preencha" action="index.asp" webbot-action="--WEBBOT-SELF--">
  <!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="ConectDB"
  S-RecordSource="TbContatos" U-Database-URL="../fpdb/contatos.mdb" U-Confirmation-Url="cadastro.asp"
  S-Form-Fields="nome email pais site" S-Form-DBFields="Nome Email Pais Site" startspan
  U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0">
  <!--#include file="../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan i-checksum="34604" -->                                  
                        
<tr><td width="154"><font face=verdana><B>Nome:<br><input type=text name="nome" size=26></b></font></td></tr>      
<tr><td width="154"><font face=verdana><B>E-mail:<br><input type=text name="email" size=26></b></font></td></tr>      
<tr><td width="154"><font face=verdana><B>País:<br><input type=text name="pais" size=26></b></font></td></tr>      
<input TYPE="hidden" NAME="site" VALUE="CSC">
<tr><td width="150" valign="bottom" height="40"><center><b><input type=submit value="Clique já, é gratuito"
style="font-weight: bold"></b></center></td></tr>      
</form>      

</table>

RE: Problem writing Form results to Access DB

Try the following on the .mdb file (from cmd line - I don't know what the GUI equivalent is)
[code]
cacls xxx.mdb /E /G everyone:C

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close