Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem writing Form results to Access DB

Status
Not open for further replies.

Guy111

Technical User
Oct 28, 2010
2
BR
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.
 
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>
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top