I am trying to connect to an Access 2000 database to insert data gathered from a simple form on a previous page. All of this is fairly straightforward but for some reason, neither work.<BR><BR>Here is my code:<BR><BR>&#060;%<BR><BR>Set ObjConn = Server.CreateObject("ADODB.Connection")<BR><BR>&#0 39---Standard DSN-less Connection---<BR>&#039ObjConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=D:InetpubHttpBj~candidatesalsurvey200 1-survsurv2001.mdb;UID=;PWD=;"<BR><BR>&#039---OLEDB Connection---<BR>ObjConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:InetpubHttpBj~candidatesalsurvey2001-survsurv2001.mdb"<BR><BR>ObjConn.ConnectionTimeout = 20<BR>ObjConn.Open<BR><BR>Set FS = Server.CreateObject("ADODB.RecordSet")<BR> FS.Open "surv2001", ObjConn<BR><BR> FS.AddNew<BR><BR> FS("sex") = Request("sex")<BR> FS("age") = Request("age")<BR> FS("experience") = Request("experience")<BR> FS("raise") = Request("raise")<BR> FS("salary") = Request("salary")<BR> FS("raise_list") = Request("raise_list")<BR> FS("salary_num") = Request("salary_num")<BR> FS("hours") = Request("hours")<BR> FS("education") = Request("education")<BR> FS("state") = Request("state")<BR> FS("industry") = Request("industry")<BR> FS("position") = Request("position")<BR><BR> FS.Update<BR><BR>FS.Close<BR>Set FS = Nothing<BR>ObjConn.Close<BR>Set ObjConn = Nothing<BR><BR>Response.Redirect("CNthanks.asp")<B R><BR>%&#062;<BR><BR>I&#039ve tried toying around with cursor types, i&#039ve added a ConnectionTimeout property, done this and that, all to no avail.<BR><BR>The path to the database is verified correct.<BR>The newest version of MDAC is installed on the server.<BR><BR>Here are the errors I get:<BR><BR>For DSN-less - <BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 8007000e&#039 <BR>[Microsoft][ODBC Microsoft Access Driver] System resource exceeded. <BR><BR>/~candidate/salsurvey/2001-surv/CNprocess.asp, line 5<BR><BR>For OLEDB - <BR><BR>Microsoft JET Database Engine error &#039 80004005&#039 <BR><BR>Unspecified error <BR><BR>/~candidate/salsurvey/2001-surv/CNprocess.asp, line 12 <BR><BR><BR>I&#039ve done searches on this forum for these two related errors and it turns out no one really knows.<BR><BR>Anyone out there have ANY idea about this?<BR>