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?
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.
Ambition is a poor excuse for those without
sense enough to be lazy.
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.
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.
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=windows-1252">
If IsObject(Session("tblCity_conn")) Then
Set conn = Session("tblCity_conn")
Set conn = Server.CreateObject("ADODB.Connection")
Set Session("tblCity_conn") = conn
If IsObject(Session("tblCity_rs")) Then
Set rs = Session("tblCity_rs")
sql = "SELECT * FROM [tblCity]"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
If rs.eof Then
Set Session("tblCity_rs") = rs
<TABLE BORDER=1 BGCOLOR=#ffffff CELLSPACING=0><FONT FACE="Arial" COLOR=#000000><CAPTION><B>tblCity</B></CAPTION></FONT>