Help desperately needed

[jjdesigns]

Hi, i am making a database in Access, and using it with Front Page. I have entered the coding in ASP but the database doesnt seem to be appearing on the screen. This is the coding I have used:

<%
Dim strConnect

strConnect = &quot;Provider=Microsoft.Jet.OLEDB.OLEDB.4.0;Data Source=&quot; & server.mappath(&quot;estimates.mdb&quot

Dim objRS

Dim totalprice, itemprice, itemname

Set objRS = Server.CreateObject(&quot;ADODB.Recordset&quot
objRS.Open &quot;Jobs&quot;, strConnect, adOpenStatic, adLockReadOnly, CmdTable

Response.Write &quot;<TABLE BORDER=&quot;&quot;0&quot;&quot; width=&quot;&quot;100%&quot;&quot;>
Response.Write &quot;<TR>&quot;
Response.Write &quot;<TD width=&quot;&quot;300&quot;&quot;><font size=&quot;&quot;1&quot;&quot; face=&quot;&quot;Verdana&quot;&quot;><B>Job Description</B></font></td>&quot;
Response.Write &quot;<TD width=&quot;&quot;100&quot;&quot;><font size=&quot;&quot;1&quot;&quot; face=&quot;&quot;Verdana&quot;&quot;><B>Job Quote</B></font></td>&quot;
Response.Write &quot;<TD width=&quot;&quot;100&quot;&quot;><font size=&quot;&quot;1&quot;&quot; face=&quot;&quot;Verdana&quot;&quot;><B>Click Here</B></font></td>&quot;

If Not objRS.EOF Then
While NOT objRS.EOF
Response.Write &quot;<TR>&quot;
Response.Write &quot;<TD valign=&quot;&quot;top&quot;&quot;><font size=&quot;&quot;1&quot;&quot; face=&quot;&quot;Verdana&quot;&quot;>&quot; & objRS(&quot;Job Description&quot & &quot; </font></TD>&quot;
Response.Write &quot;<TD valign=&quot;&quot;top&quot;&quot;><font size=&quot;&quot;1&quot;&quot; face=&quot;&quot;Verdana&quot;&quot;>&quot; & objRS(&quot;Job price&quot & &quot; </font></TD>&quot;
Response.Write &quot;<TD vaiign=&quot;&quot;top&quot;&quot;><font size=&quot;&quot;1&quot;&quot; face=&quot;&quot;Verdana&quot;&quot;> </font></TD>&quot;
objRS.MoveNext
Wend
End If

Response.Write &quot;</TABLE>&quot;
objRS.Close
Set objRS = Nothing

%>

can someone please tell me where I have gone wrong, much appreciated...

 

[durug]

try to copy the file on the HDD. What is the error?????

 

[jjdesigns]

its saying this page contains elements that may need to be published

 

[durug]

Copy the asp files under the location that Jonax mentioned. Copy the DB on the HDD. Change the connection string for the DB to the new location and then tell us what is going on.
Also, don't forget to access the asp page like Jonax mentioned.

Jonax hope you name and words are not copyright?

 

[jjdesigns]

ive just got to do something quickly, i will be back shortly...

 

[Jonax]

This is not a bug - it's an undocumented feature...
;-)

 

[Guest_imported]

ASP pages can't be viewed in front page. Publish them and view with your browser. When you make a change, save the change to the server, then refresh your browser to reflect the change. If you use the diriect path to the file take out the server.mappath and just put in the whole path. Put your DB in your web in a folder called FPDB and let frontpage make a connection in a global.asa. You don't need the connection in the global.asa, but it usualy then sets the FPDB folder with shared permissions. At that point you can use a DSNless connection