Personal Web Server

**carol** · Nov 11, 2001, 15:00

I am trying to export an access 200 table to an asp, view and edit it in localhost .
I am able to view it but it is not editable.
I have done it before but can't get it to work this time.
I think it might be because of the DSN I created.
I am using Windows 98.
For the DSN I specified a name. Chose *.mdb for the connection and chose the database to connect to.
That is all I did. (that's all I thought I did last time also)
What am I missing?

Thanks again,

Carol:

**Aes** · Nov 11, 2001, 15:16

This thread should be moved to a more appropriate forum; you'll get better responses there.

**carol** · Nov 11, 2001, 15:26

Thanks for letting me know.

Any idea where would be appropriate?
I'm a complete beginner.
Thanks
Carol

**Aes** · Nov 11, 2001, 15:46

Don't worry about it; an advisor should move it shortly. You weren't exactly in the wrong, so to speak, about posting it here. It should be moved just because the members who are likely to know how to answer your question are more likely to see this thread in onw of the other channels.

**iTec** · Nov 12, 2001, 02:06

carol if you can view the data from the database, but not write to the database then it is not a problem with your dsn. it is most likely a problem with your code whe trying to write to the database, did you write/buy/download the code?

also are there any error messages that appear when you try to edit the code? if so posting it here might help track were the problem lies.

**carol** · Nov 12, 2001, 10:19

When you use the export function from Access 2000 to create an asp page it generates the code for you. see below.
I navigated the where I saved the form using internet explorer.
http://localhost/filename.asp to view it. It worked a few months ago. Could something in my Personal Web Server not be set up right? scripts is enabled and read is enabled. By the way I reposted this to ASP forum yesterday. I didn't mean to have 2 threads going.
Sorry
Thanks
Carol

<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
<TITLE>tblCity</TITLE>
</HEAD>
<BODY>
<%
If IsObject(Session("tblCity_conn")) Then
Set conn = Session("tblCity_conn")

Else
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "tblCity","",""
Set Session("tblCity_conn") = conn

End If
%>
<%
If IsObject(Session("tblCity_rs")) Then
Set rs = Session("tblCity_rs")
Else
sql = "SELECT * FROM [tblCity]"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
If rs.eof Then
rs.AddNew
End If
Set Session("tblCity_rs") = rs
End If
%>
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0><FONT FACE="Arial" COLOR=#000000><CAPTION><B>tblCity</B></CAPTION></FONT>

<THEAD>
<TR>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="Arial" COLOR=#000000>City</FONT></TH>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000 ><FONT SIZE=2 FACE="Arial" COLOR=#000000>Hyperlink</FONT></TH>

</TR>
</THEAD>
<TBODY>
<%
On Error Resume Next
rs.MoveFirst
do while Not rs.eof
%>
<TR VALIGN=TOP>
<TD BORDERCOLOR=#c0c0c0 ><FONT SIZE=2 FACE="Arial" COLOR=#000000><%=Server.HTMLEncode(rs.Fields("City").Value)%><BR></FONT></TD>
<TD BORDERCOLOR=#c0c0c0 ><U><FONT SIZE=2 FACE="Arial" COLOR=#0000ff><%=Server.HTMLEncode(rs.Fields("Hyperlink").Value)%><BR></FONT></U></TD>

</TR>
<%
rs.MoveNext
loop%>
</TBODY>
<TFOOT></TFOOT>
</TABLE>
</BODY>
</HTML>

**carol** · Nov 13, 2001, 18:24

Did I do something Wrong? or is this something that nobody here knows about.
If anyone can explain DSN's to me. (the little bit I know came from the Access 2000 developer's handbook.

I'm pretty sure it is something I am doing wrong in my DSN set up.
Desparately still trying.
Carol

User Tag List

Thread: Personal Web Server

Thread Tools

Display

Personal Web Server

Personal Web Server

Did I do something Wrong?

Bookmarks

Bookmarks

Posting Permissions