Use esse: conecta.asp <%
local=Request.ServerVariables("SERVER_NAME")
if local="www.site.com.br" or local="site.com.br" then
conexao = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\inetpub\site\site.com.br\data\bd.mdb;Persist Security Info=False"
end if
if local="localhost" or local="nome_do_pc" then
conexao= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\pasta\bd.mdb;Persist Security Info=False"
end if
set conn = Server.CreateObject("adodb.connection")
conn.open conexao
%>
incluir_script.asp
<!--#include file="conecta.asp"-->
<%set RecSet = server.createobject("adodb.recordset")
if request.form("acao") <> "" then
conn.execute "insert into produto (ref, categoria, nome, descr, medidas, preço, foto) values ('"&request.form("sRef")&"', '"&request.form("sCategoria")&"', '"&request.form("sNome&")"', '"&request.form("sDescr&")"', '"&request.form("sMedida")&"', '"&request.form("sPreco")&"', '"&request.form("sFoto")&"')"
response.write "cadastrado"
else
%>
<script language="JavaScript">
<!--
function verificar()
{
var fcad = document.forms[0];
if(fcad.ref.value==0)
{
window.alert("Favor especificar uma REF.");
fcad.ref.focus();
return false;
}
}
//-->
</script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000" link="#000000" vlink="#000000" alink="#000000">
<form method="post" action="incluir_script.asp" enctype="MULTIPART/FORM-DATA" onSubmit="return verificar();">
<input type=hidden name="hdn_submit" value="1">
<table width="440" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="94" height="30"> <div align="center">
<p align="center"><img src="logo_pq.jpg" width="84" height="105"><font color="#000080"><b><font face="Arial, Helvetica, sans-serif" size="2">
</font></b></font></p>
</div></td>
<td width="350" height="30"><div align="center"><font color="#000080"><b><font face="Arial, Helvetica, sans-serif" size="2">Formulário
de Inclusão de Produtos</font></b></font><br>
<font color="#000080"><b><font face="Arial, Helvetica, sans-serif" size="1">(Administrativo)</font></b></font></div></td>
</tr>
<tr>
<td height="17" colspan="2"> <div align="right"><a
href="javascript:history.back()"><font color="#000000"><b><font size="1" face="Verdana,
Arial, Helvetica, sans-serif">VOLTAR</font></b></font></a></div></td>
</tr>
<tr>
<td height="20" colspan="2"><font color="#000000">_______________________________________________________</font>
<p></td>
</tr>
<tr>
<td height="25" colspan="2"> <table width="440" border="0" cellspacing="0" cellpadding="0" height="25">
<tr>
<td width="188" height="25" align="right"><b><font face="Arial, Helvetica, sans-serif" size="2" color="#000000">ref.:
</font></b></td>
<td width="252" height="25" align="left"><b><font face="Arial, Helvetica, sans-serif" size="2" color="#000000">
<input type="text" name="ref" size="10" maxlength="15">
</font></b></td>
</tr>
<tr>
<td width="188" height="25" align="right"><font color="#000000"><b><font face="Arial, Helvetica, sans-serif" size="2"> </font><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"> Nome
do Produto:</font></b></font><font color="#000000"><b><font face="Arial, Helvetica, sans-serif" size="2">
</font></b></font></td>
<td width="252" height="25" align="left"><font color="#000000"><b></b></font><font color="#000000"><b><font color="#000000"><b><font face="Arial, Helvetica, sans-serif" size="2">
</font><font face="Arial, Helvetica, sans-serif" size="2" color="#000000">
<input type="text" name="nome" size="20" maxlength="30">
</font><font face="Arial, Helvetica, sans-serif" size="2"> </font></b></font><font face="Arial, Helvetica, sans-serif" size="2">
</font></b></font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" colspan="2"> <table width="440" border="0" cellspacing="0" cellpadding="0" height="25">
<tr>
<td width="188" height="25" align="right"><font color="#000000"> <b><font size="2" face="Arial, Helvetica, sans-serif">Linha:</font></b>
</font></td>
<td width="252" height="25"><font color="#000000">
<select name="categoria">
<option value="aparadores">Aparadores</option>
<option value="balcões">Balcões</option>
<option value="banqueta clássica">Banqueta Clássica</option>
<option value="banqueta contemporânea">Banqueta Contemporânea</option>
<option value="clássica">Cadeira Clássica</option>
<option value="cadeira escritório">Cadeira Escritório</option>
<option value="cadeira madeira">Cadeira Madeira</option>
<option value="cadeira metal">Cadeira Metal</option>
<option value="equipe">Equipe</option>
<option value="estofados">Estofados</option>
<option value="home theater">Home Theater e Racks</option>
<option value="jardim">Jardim</option>
<option value="lazer">Lazer</option>
<option value="acessórios luminária">Luminárias</option>
<option value="mesa apoio">Mesa Apoio/Auxiliar</option>
<option value="mesa centro">Mesa Centro</option>
<option value="mesa jantar">Mesa Jantar</option>
<option value="acessórios objetos">Objetos</option>
<option value="piscinas">Piscinas</option>
<option value="poltrona clássica">Poltrona Clássica</option>
<option value="poltrona contemporânea">Poltrona Contemporânea</option>
<option value="sala de estar">Sala de Estar</option>
<option value="sala de jantar">Sala de Jantar</option>
<option value="acessórios tapete">Tapetes</option>
</select>
</font></td>
</tr>
<tr>
<td width="188" height="25" align="right"><font color="#000000"><b><font face="Arial, Helvetica, sans-serif" size="2">Medidas:</font></b></font></td>
<td width="252" height="25"><font color="#000000"><b><font face="Arial, Helvetica, sans-serif" size="2">
<input type="text" name="medida" size="20" maxlength="30">
</font></b></font><font color="#FFFFFF"><b></b></font> <font color="#000000">
</font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" colspan="2"> <div align="center"><font color="#000000"><b><font face="Arial, Helvetica, sans-serif" size="2">Selecione
a Imagem para Upload:</font></b></font></div></td>
</tr>
<tr>
<td align="center" height="25" colspan="2"> <font color="#000000">
<% If sFoto <> "" Then %>
<a href="mostrar_foto.asp?foto=<%=sFoto%>" target=_blank><%= sFoto %></a>.<br>
<input type="radio" name="manter_enviar" value="M" checked>
<font size="2" face="Verdana, Arial, Helvetica, sans-serif">Manter ou
<input type="radio" name="manter_enviar" value="E">
Enviar outra</font>.<br>
<input type="hidden" name="path_foto_server" value="<%= sFoto %>">
<%End If %>
<input type="file" name="foto" maxlength="50" size="25" value="">
</font> </td>
</tr>
<tr>
<td height="25" colspan="2"> <div align="center"><font color="#000000"> <b><font face="Arial, Helvetica, sans-serif" size="2">Descrição</font></b></font></div></td>
</tr>
<tr>
<td height="60" colspan="2"> <div align="center"><font face="Verdana" size="1" color="#000000">
<textarea rows="5" name="descr" cols="40"></textarea>
</font></div></td>
</tr>
<tr>
<td height="25" colspan="2"> </td>
</tr>
<tr>
<td height="25" colspan="2"> <div align="center"> <font color="#000000">
<input type="hidden" name="acao" value="submit"><input type="submit" name="Submit" value="Incluir">
</font></div></td>
</tr>
<tr>
<td height="25" colspan="2"><font color="#000000">_______________________________________________________</font></td>
</tr>
<tr>
<td height="25" colspan="2"> <div align="right"><font color="#000000"><a href="javascript:history.back()"><b><font size="1" face="Verdana, Arial, Helvetica, sans-serif">VOLTAR</font></b></a></font></div></td>
</tr>
</table>
</form>
<%end if
set RecSet = nothing%> Pegue esse dai...Espero ter ajudado!!! Caso tenha mais alguma dúvida, poste ae que te ajudaremos!!!! []'s Victor