Hi - <BR>I have no problems running queries with Access & the web with a dsn-less connection. Below is my dsn-less conn method and it works fine. When I choose to export a form to .asp with access 2000 it assumes I&#039;m not using a dsn-less connection and spits out what is on the very bottom, below the double line. <BR>Question: can i make access spit out a dsn-less routine when exporting and / or how do I &#039;convert&#039; the one below (bottom) into a a dsn-less connection. thanks - cjam<BR>----------------------------------------------------<BR>&#039;dsn-less<BR>accessdb="questweb2k1.mdb"<BR>cString="dri ver={Microsoft Access Driver (*.mdb)};" & _<BR>"pwd=hammer;" &_<BR>"DBQ=" & _<BR>Server.MapPath("questweb2k1.mdb")<BR>sql="SEL ECT * from Lesson;"<BR><BR>Set conn=Server.CreateObject("ADODB.Connection")<BR>co nn.Open (cString)<BR>Set onQuest=conn.execute(sql)<BR>===================== ===================================<BR>=========== =============================================<BR>& #039;access spit out<BR>If IsObject(Session("questweb2k1.mdb_conn")) Then<BR> Set conn = Session("questweb2k1.mdb_conn")<BR>Else<BR> Set conn = Server.CreateObject("ADODB.Connection")<BR> conn.open "questweb2k1.mdb","","hammer"<BR> Set Session("questweb2k1.mdb_conn") = conn<BR>End If<BR>%&#062;<BR>&#060;%<BR>If IsObject(Session("Lesson_rs")) Then<BR> Set rs = Session("Lesson_rs")<BR>Else<BR> sql = "SELECT * FROM [Lesson]"<BR> Set rs = Server.CreateObject("ADODB.Recordset")<BR> rs.Open sql, conn, 3, 3<BR> If rs.eof Then<BR> rs.AddNew<BR> End If<BR> Set Session("Lesson_rs") = rs<BR>End If