Hey Guys,

Just want to say once again that I appreciate all the help everyone has given me in the past. You have saved me many hours and headaches in the past. Hopefully someone will have an idea with this one. I keep getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''y' y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', ''.

/portal/Portal/practicum2/admin_sites-add_exe3.asp, line 471


When using one of my forms. I used Response.Write to view the query and it seems fine, but it is so large that it is hard to tell. I did have this working at one point, but after a server crash and restore I did not have the most up-to-date version. Here is the form code:

<title>Add Site:</title>

<center>

<h3><b>Training Site Information Form</b></h3>
<form action="admin_sites-add_exe3.asp" method="post" name="edit_show">
  <table width="780" border="0">
  <tr>
<input type="hidden" name="ID" value="<%= Request.QueryString("ID") %>" />
</tr>
  <tr>
    <td colspan="6"><strong>Position Information</strong>

      </td>
  </tr>
  <tr>
    <td colspan="3"><input name="site_pi-osd" type="text" size="3">
    <strong>Open Start Date (Y/N) <br>
         (i.e., position may start anytime during the year) </strong></td>
    <td colspan="3"><input name="site_pi-ssd" type="text" size="3">
    <strong>Structured Start Date (Y/N) </strong></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="2"><div align="center">[u]<strong>Summer Start </strong></u></div></td>
    <td colspan="2"><div align="center">[u]<strong>Fall Start</strong></u></div></td>
    <td colspan="2"><div align="center">[u]<strong>Spring Start </strong></u></div></td>
  </tr>
  <tr>
    <td><div align="center"><input name="site_pi-su-sm" type="text" size="15">
    to <input name="site_pi-su-em" type="text" size="15">
    </div></td>
    <td><div align="center">(<input name="site_pi-su-nm" type="text" size="3">
    # months) </div></td>
    <td><div align="center"><input name="site_pi-fa-sm" type="text" size="15">
    to <input name="site_pi-fa-em" type="text" size="15">
    </div></td>
    <td><div align="center">(<input name="site_pi-fa-nm" type="text" size="3">
    #
    months) </div></td>
    <td><div align="center"><input name="site_pi-sp-sm" type="text" size="15">
    to <input name="site_pi-sp-em" type="text" size="15">
    </div></td>
    <td><div align="center">(<input name="site_pi-sp-nm" type="text" size="3">
    # months) </div></td>
  </tr>
  <tr>
    <td><div align="center"><strong>Flexible <br>
    Start</strong> <input name="site_pi-su-fs" type="text" size="3">
    (Y/N)</div></td>
    <td><div align="center"><strong>Flexible <br>
    End</strong> <input name="site_pi-su-fe" type="text" size="3">
    (Y/N)</div></td>
    <td><div align="center"><strong>Flexible <br>
    Start</strong> <input name="site_pi-fa-fs" type="text" size="3">
    (Y/N)</div></td>
    <td><div align="center"><strong>Flexible <br>
    End</strong> <input name="site_pi-fa-fe" type="text" size="3">
    (Y/N)
    </div></td>
    <td><div align="center"><strong>Flexible <br>
    Start</strong> <input name="site_pi-sp-fs" type="text" size="3">
    (Y/N)</div></td>
    <td><div align="center"><strong>Flexible <br>
    End</strong> <input name="site_pi-sp-fe" type="text" size="3">
    (Y/N)</div></td>
  </tr>
  <tr>
    <td><div align="center"><strong>Average <br>
    Days/Week </strong></div></td>
    <td><input name="site_pi-su-adw" type="text" size="3">
    (#) </td>
    <td><div align="center"><strong>Average <br>
    Days/Week </strong></div></td>
    <td><input name="site_pi-fa-adw" type="text" size="3"> (#)</td>
    <td><div align="center"><strong>Average <br>
    Days/Week</strong> </div></td>
    <td><input name="site_pi-sp-adw" type="text" size="3"> (#)</td>
  </tr>
  <tr>
    <td><div align="center"><strong>Average <br>
    Hours/Week </strong></div></td>
    <td><input name="site_pi-su-ahw" type="text" size="3"> (#)</td>
    <td><div align="center"><strong>Average <br>
    Hours/Week </strong></div></td>
    <td><input name="site_pi-fa-ahw" type="text" size="3"> (#)</td>
    <td><div align="center"><strong>Average <br>
    Hours/Week </strong></div></td>
    <td><input name="site_pi-sp-ahw" type="text" size="3"> (#)</td>
  </tr>
  <tr>
    <td><div align="center"><strong>Average <br>
    Total Hours </strong></div></td>
    <td><input name="site_pi-su-ath" type="text" size="3"> (#)</td>
    <td><div align="center"><strong>Average <br>
    Total Hours </strong></div></td>
    <td><input name="site_pi-fa-ath" type="text" size="3">
      (#)</td>
    <td><div align="center"><strong>Average <br>
    Total Hours </strong></div></td>
    <td><input name="site_pi-sp-ath" type="text" size="3">
      (#)</td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td><strong>Required Training Days (Y/N) </strong></td>
    <td><input name="site_pi-rtd-mo" type="text" size="3">
    -M <input name="site_pi-rtd-tu" type="text" size="3">
    -T<br>
    <input name="site_pi-rtd-we" type="text" size="3">
    -W <input name="site_pi-rtd-th" type="text" size="3">
    -R<br>
    <input name="site_pi-rtd-fr" type="text" size="3">
    -F <input name="site_pi-rtd-sa" type="text" size="3">
    -Sa<br>
    <input name="site_pi-rtd-su" type="text" size="3">
    -Su</td>
    <td><strong>Weekend Training Available?</strong></td>
    <td><input name="site_pi-wta" type="text" size="3">
    (Y/N)</td>
    <td><strong>Evenings Available?</strong></td>
    <td><input name="site_pi-ea" type="text" size="3">
    (Y/N) </td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Benefits</strong></td>
  </tr>
  <tr>
    <td><strong>Stipend</strong></td>
    <td>$<input name="site_pi-ben-stp" type="text" size="10"></td>
    <td><strong>per
        <select name="site_pi-ben-per" size="1">

      </select>
    </strong></td>
    <td>&nbsp; </td>
    <td><strong>Vacation Days/Year </strong></td>
    <td><input name="site_pi-ben-vdy" type="text" size="3">
    (#) </td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr valign="top">
    <td colspan="2"><strong>Description of Ideal Candidate </strong></td>
    <td colspan="4"><textarea name="site_pi-dic" cols="50" rows="5"></textarea></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr valign="top">
    <td colspan="2"><strong>Position Description </strong></td>
    <td colspan="4"><textarea name="site_pi-pd" cols="50" rows="5"></textarea></td>
  </tr>
  <tr>
    <td colspan="6"><div align="right"><strong>Link to Job Posting:</strong>
      <input name="site_pi-hpp" type="text" size="40">
    </a></div></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><div align="center"><strong>This site would provide a good training experience for PsyD students interested in the following concentrations: (Y/N) </strong></div></td>
  </tr>
  <tr>
    <td><input name="site_pi-pc-ca" type="text" size="3">
    Child / <br> Adolescent </td>
    <td><input name="site_pi-pc-ec" type="text" size="3">
    Expressive <br> &amp; Creative Arts </td>
    <td><input name="site_pi-pc-or" type="text" size="3">
    Organizational</td>
    <td><input name="site_pi-pc-he" type="text" size="3">
    Health </td>
    <td><input name="site_pi-pc-mc" type="text" size="3">
    Multicultural </td>
    <td><input name="site_pi-pc-fo" type="text" size="3">
    Forensic </td>
  </tr>
</table>
<br>

<table width="780" border="0">
    <tr>
    <td colspan="2"><strong>Site Populations </strong>
        </td>
  </tr>
  <tr>
    <td width="146"><strong>Clientele Description </strong></td>
    <td width="624"><textarea name="site_sp-cd" cols="50" rows="5"></textarea></td>
  <tr>
    <td colspan="2"><div align="right"> Clientele Details </div></td>
  </tr>
</table>
<br>
<table width="780" border="0">
  <tr>
    <td colspan="8"><div align="left"><strong>Training Activities </strong> </div>
        </td>
  </tr>
  <tr>
    <td colspan="8"><div align="left"><strong>Clinical &amp; Forensic Intervention Activities (Y/N) </strong></div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-cfis-itc" type="text" size="3">
    </div></td>
    <td><div align="left">Individual Therapy<br>
        / Counseling</div></td>
    <td><div align="right">
        <input name="site_ta-cfia-gtc" type="text" size="3">
    </div></td>
    <td><div align="left">Group Therapy<br>
        / Counseling </div></td>
    <td><div align="right">
        <input name="site_ta-cfia-ftc" type="text" size="3">
    </div></td>
    <td><div align="left">Family Therapy<br>
        / Counseling </div></td>
    <td><div align="right">
        <input name="site_ta-cfia-ctc" type="text" size="3">
    </div></td>
    <td><div align="left">Couples Therapy<br>
        / Counseling </div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-cfia-cc" type="text" size="3">
    </div></td>
    <td><div align="left">Career Counseling </div></td>
    <td><div align="right">
        <input name="site_ta-cfia-sc" type="text" size="3">
    </div></td>
    <td><div align="left">School Counseling </div></td>
    <td><div align="right">
        <input name="site_ta-cfia-mt" type="text" size="3">
    </div></td>
    <td><div align="left">Milieu Therapy </div></td>
    <td><div align="right">
        <input name="site_ta-cfia-ci" type="text" size="3">
    </div></td>
    <td><div align="left">Crisis Intervention</div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-cfia-cm" type="text" size="3">
    </div></td>
    <td><div align="left">Case Management </div></td>
    <td><div align="right">
        <input name="site_ta-cfia-mhi" type="text" size="3">
    </div></td>
    <td><div align="left">Medical/Health <br>
        Interventions</div></td>
    <td><div align="right">
        <input name="site_ta-cfia-sai" type="text" size="3">
    </div></td>
    <td><div align="left">Substance Abuse Interventions</div></td>
    <td><div align="right">
        <input name="site_ta-cfia-pd" type="text" size="3">
    </div></td>
    <td><div align="left">Program<br>
        Development </div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-cfia-op" type="text" size="3">
    </div></td>
    <td><div align="left">Outreach Programming </div></td>
    <td><div align="right">
        <input name="site_ta-cfia-sp" type="text" size="3">
    </div></td>
    <td><div align="left">Sports Psychology</div></td>
    <td><div align="right">
        <input name="site_ta-cfia-cla" type="text" size="3">
    </div></td>
    <td><div align="left">Court Liaison/Advocacy </div></td>
    <td><div align="right">
        <input name="site_ta-cfia-sos" type="text" size="3">
    </div></td>
    <td><div align="left">Supervision of <br>
        Other Students </div></td>
  </tr>
  <tr>
    <td><div align="right">&nbsp;&nbsp;</div></td>
    <td><div align="left">Other</div></td>
    <td colspan="6"><div align="left">
        <input name="site_ta-cfia-ot" type="text" size="40">
    </div></td>
  </tr>
  <tr>
    <td colspan="8"><div align="right">&nbsp;&nbsp;</div></td>
  </tr>
  <tr>
    <td colspan="8"><div align="left"><strong>Clinical &amp; Forensic Assessment Activities (Y/N) </strong></div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-cfaa-ii" type="text" size="3">
    </div></td>
    <td><div align="left">Intake Interviews</div></td>
    <td><div align="right">
        <input name="site_ta-cfaa-si" type="text" size="3">
    </div></td>
    <td><div align="left">Structured Interviews </div></td>
    <td><div align="right">
        <input name="site_ta-cfaa-dci" type="text" size="3">
    </div></td>
    <td><div align="left">Diagnostic Clinical Interviews </div></td>
    <td><div align="right">
        <input name="site_ta-cfaa-mse" type="text" size="3">
    </div></td>
    <td><div align="left">Mental Status Exam </div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-cfaa-pt" type="text" size="3">
    </div></td>
    <td><div align="left">Projective Testing </div></td>
    <td><div align="right">
        <input name="site_ta-cfaa-ot" type="text" size="3">
    </div></td>
    <td><div align="left">Objective Testing </div></td>
    <td><div align="right">
        <input name="site_ta-cfaa-srm" type="text" size="3">
    </div></td>
    <td><div align="left">Self-Report Measures </div></td>
    <td><div align="right">
        <input name="site_ta-cfaa-it" type="text" size="3">
    </div></td>
    <td><div align="left">Intelligence Testing </div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-cfaa-ldt" type="text" size="3">
    </div></td>
    <td><div align="left">Learning Disability Testing </div></td>
    <td><div align="right">
        <input name="site_ta-cfaa-aat" type="text" size="3">
    </div></td>
    <td><div align="left">Achievement/Aptitude <br>
        Testing </div></td>
    <td><div align="right">
        <input name="site_ta-cfaa-nt" type="text" size="3">
    </div></td>
    <td><div align="left">Neuropsychological Testing</div></td>
    <td><div align="right">&nbsp;</div></td>
    <td><div align="left">&nbsp;</div></td>
  </tr>
  <tr>
    <td><div align="right">&nbsp;&nbsp;</div></td>
    <td><div align="left">Other</div></td>
    <td colspan="6"><div align="left">
        <input name="site_ta-cfaa-othert" type="text" size="40">
    </div></td>
  </tr>
  <tr>
    <td colspan="8"><div align="right"> Assessment Activity Details </div></td>
  </tr>
  <tr>
    <td colspan="8"><div align="right">&nbsp;&nbsp;</div></td>
  </tr>
  <tr>
    <td colspan="8"><div align="left"><strong>Industrial &amp; Organizational Services (Y/N)</strong></div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-ios-ic" type="text" size="3">
    </div></td>
    <td><div align="left">Internal Consulting</div></td>
    <td><div align="right">
        <input name="site_ta-ios-ec" type="text" size="3">
    </div></td>
    <td><div align="left">External Consulting </div></td>
    <td><div align="right">
        <input name="site_ta-ios-hr" type="text" size="3">
    </div></td>
    <td><div align="left">Human Resoures </div></td>
    <td><div align="right">&nbsp;</div></td>
    <td><div align="left">&nbsp;</div></td>
  </tr>
  <tr>
    <td colspan="8"><div align="right">&nbsp;&nbsp;</div></td>
  </tr>
  <tr>
    <td colspan="8"><div align="left"><strong>Industrial &amp; Organizational Activites </strong></div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-ioa-rps" type="text" size="3">
    </div></td>
    <td><div align="left">Recruiting/Personnel Selection</div></td>
    <td><div align="right">
        <input name="site_ta-ioa-in" type="text" size="3">
    </div></td>
    <td><div align="left">Interviewing</div></td>
    <td><div align="right">
        <input name="site_ta-ioa-ja" type="text" size="3">
    </div></td>
    <td><div align="left">Job Analysis</div></td>
    <td><div align="right">
        <input name="site_ta-ioa-jd" type="text" size="3">
    </div></td>
    <td><div align="left">Job Design </div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-ioa-fg" type="text" size="3">
    </div></td>
    <td><div align="left">Focus Groups </div></td>
    <td><div align="right">
        <input name="site_ta-ioa-sdd" type="text" size="3">
    </div></td>
    <td><div align="left">Survey Design &amp; <br>
        Delivery </div></td>
    <td><div align="right">
        <input name="site_ta-ioa-cc" type="text" size="3">
    </div></td>
    <td><div align="left">Career Counseling </div></td>
    <td><div align="right">
        <input name="site_ta-ioa-mr" type="text" size="3">
    </div></td>
    <td><div align="left">Market Research </div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-ioa-sp" type="text" size="3">
    </div></td>
    <td><div align="left">Succession Planning </div></td>
    <td><div align="right">
        <input name="site_ta-ioa-tdd" type="text" size="3">
    </div></td>
    <td><div align="left">Training Design &amp; <br>
        Delivery </div></td>
    <td><div align="right">
        <input name="site_ta-ioa-ic" type="text" size="3">
    </div></td>
    <td><div align="left">Internal Communications </div></td>
    <td><div align="right">
        <input name="site_ta-ioa-shp" type="text" size="3">
    </div></td>
    <td><div align="left">Strategic HR Planning </div></td>
  </tr>
  <tr>
    <td><div align="right">
        <input name="site_ta-ioa-aap" type="text" size="3">
    </div></td>
    <td><div align="left">Affirmative Action Planning </div></td>
    <td><div align="right">
        <input name="site_ta-ioa-pm" type="text" size="3">
    </div></td>
    <td><div align="left">Performance <br>
        Management </div></td>
    <td><div align="right">
        <input name="site_ta-ioa-cba" type="text" size="3">
    </div></td>
    <td><div align="left">Compensation/Benefits<br>
        Administration</div></td>
    <td><div align="right">&nbsp;&nbsp;</div></td>
    <td><div align="left">&nbsp;&nbsp;</div></td>
  </tr>
  <tr>
    <td><div align="right">&nbsp;&nbsp;</div></td>
    <td><div align="left">Other</div></td>
    <td colspan="6"><div align="left">
        <input name="site_ta-ioa-other" type="text" size="40">
    </div></td>
  </tr>
</table>
<br>
<table width="780" border="0">
  <tr>
    <td colspan="3"><strong>Research Opportunities</strong>
        </td>
  </tr>
  <tr>
    <td width="230"><strong>Research Opportunities Available</strong> </td>
    <td width="44"><input name="site_ro-roa" type="text" size="3">
    (Y/N)</td>
    <td width="492"><input name="site_ro-roat" type="text" size="40"></td>
  </tr>
</table>
<br>
<table width="780" border="0">
  <tr>
    <td colspan="4"><strong>Training Provided</strong>
        </td>
  </tr>
  <tr>
    <td><strong>Hours of Individual Supervision per Week</strong> </td>
    <td><input name="site_tp-hisw" type="text" size="3">
    (#) </td>
    <td><strong>Hours of Group Supervision per Week</strong> </td>
    <td><input name="site_tp-hgsw" type="text" size="3">
    (#) </td>
  </tr>
  <tr>
    <td><strong>Other Learning Experiences Available</strong></td>
    <td colspan="3"><input name="site_tp-olea" type="text" size="40"></td>
  </tr>
  <tr>
    <td colspan="4">&nbsp;&nbsp;</td>
  </tr>
  <tr>
    <td><strong>Training Philosophy</strong></td>
    <td colspan="3"><textarea name="site_tp-tp" cols="50" rows="5"></textarea></td>
  </tr>
</table>
<br>
<table width="780" border="0">
    <tr>
    <td colspan="6"><strong>Application &amp; Offers </strong>
        </td>
  </tr>
  <tr>
    <td colspan="6"><strong>Application Materials </strong></td>
  </tr>
  <tr>
    <td><input name="site_ao-am-cl" type="text" size="3"></td>
    <td>Cover Letter (Y/N) </td>
    <td><input name="site_ao-am-rcv" type="text" size="3"></td>
    <td>Resume/Curriculum Vitae (Y/N) </td>
    <td><input name="site_ao-am-lr" type="text" size="3"></td>
    <td>Letters of Recommendation (
        <input name="site_ao-am-lrn" type="text" size="3">
      - #)</td>
  </tr>
  <tr>
    <td><input name="site_ao-am-tr" type="text" size="3"></td>
    <td>Transcript (Y/N) </td>
    <td><input name="site_ao-am-saf" type="text" size="3"></td>
    <td>Site Application Form <br>
        <input name="site_ao-am-safh" type="text" size="40">
        <br>
        Web Address
    </td>
    <td><input name="site_ao-am-bc" type="text" size="3"></td>
    <td>Background Check (Y/N) </td>
  </tr>
  <tr>
    <td>&nbsp;&nbsp;</td>
    <td>Writing Sample (
        <input name="site_ao-am-ws" type="text">
        ) </td>
    <td>&nbsp;</td>
    <td colspan="3">Other
        <input name="site_ao-am-other" type="text" size="40">
    </td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Method of Preferred Contact (Y/N) </strong></td>
  </tr>
  <tr>
    <td><input name="site_ao-mpc-al" type="text" size="3"></td>
    <td colspan="5">Students (Forensic MA) should abide by the application timeline and process established by the Association of Chicago<br>
      Area Training Centers in Professional Psychology (ACATCPP). For the upcoming search, students may begin submitting<br>
      application materials on
      <input name="site_ao-mpc-a" type="text" size="15">
      <em>DATE FORMAT: MM/DD/YYYY</em>. </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td colspan="5"><div align="center"><em>Note: Clinical PsyD and MA students must abide by the ACATCPP practicum search timeline. </em></div></td>
  </tr>
  <tr>
    <td><input name="site_ao-mpc-b1" type="text" size="3"></td>
    <td colspan="5">Students (I/O MA &amp; Forensic MA) are welcome to apply anytime during the calendar year. The preferred method of<br>
      contact is: </td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><input name="site_ao-mpc-ba" type="text" size="3">
      Phone (Y/N) </td>
    <td>&nbsp;</td>
    <td><input name="site_ao-mpc-bb" type="text" size="3">
      Email (Y/N) </td>
    <td>&nbsp;</td>
    <td><input name="site_ao-mpc-bc" type="text" size="3">
      Postal Mail (Y/N) </td>
  </tr>
  <tr>
    <td><input name="site_ao-mpc-c1" type="text" size="3"></td>
    <td colspan="5">Students (I/O MA &amp; Forensic MA) may apply only during the following times of year:
        <input name="site_ao-mpc-c" type="text" size="15">
        <em>DATE FORMAT: MM/DD/YYYY</em> </td>
  </tr>
  <tr>
    <td><input name="site_ao-mpc-d1" type="text" size="3"></td>
    <td colspan="5">Students (any program) should NOT contact the site unless specifically directed to do so by the school (i.e., the site will<br>
      contact the school when applications are desired and students will be so notified).</td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Interview Process (Y/N) </strong></td>
  </tr>
  <tr>
    <td><input name="site_ao-ip-a" type="text" size="3"></td>
    <td colspan="5">The site interviews applicants</td>
  </tr>
  <tr>
    <td><input name="site_ao-ip-b" type="text" size="3"></td>
    <td colspan="5">The Office of Placement &amp; Training interviews applicants. Students should direct their application materials to: </td>
  </tr>
  <tr>
    <td colspan="2">&nbsp;</td>
    <td colspan="4"><strong>Manager, Office of Placement &amp; Training<br>
      Chicago School of Professional Psychology<br>
      47 West Polk, Second Floor<br>
      Chicago, Illinois 60605 </strong></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Offer Process </strong></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td colspan="5"><strong>PsyD &amp; MA Clinical Sites (Y/N) </strong></td>
  </tr>
  <tr>
    <td colspan="2"><div align="right">
        <input name="site_ao-op-pmcs-a" type="text" size="3">
    </div></td>
    <td colspan="4">The site abides by the timeline established by the Association of Chicago Area Training Centers<br>
      in Professional Psychology (ACATCPP). For the upcoming search, the site will begin making<br>
      offers at
      <input name="site_ao-op-pmcs-at" type="text" size="15">
      <em>DATE FORMAT: MM/DD/YYYY</em>. </td>
  </tr>
  <tr>
    <td colspan="2"><div align="right">
        <input name="site_ao-op-pmcs-b" type="text" size="3">
    </div></td>
    <td colspan="4">The site does not abide by the timeline established by ACATCPP (i.e., offers may be made any<br>
      time during the application process). </td>
  </tr>
  <tr>
    <td colspan="2"><div align="right">&nbsp;</div></td>
    <td colspan="4"><em>Note: Regardless of when offers are made, Clinical PsyD and MA students CANNOT,<br>
      under any circumstance, accept offers until
          <input name="site_ao-op-pmcs-c" type="text" size="15">
      DATE FORMAT: MM/DD/YYYY. </em></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td colspan="5"><strong>MA Forensic Sites (Y/N) </strong></td>
  </tr>
  <tr>
    <td colspan="2"><div align="right">
        <input name="site_ao-op-mfs-a" type="text" size="3">
    </div></td>
    <td colspan="4">The site abides by the timeline established by the Association of Chicago Area Training Centers<br>
      in Professional Psychology (ACATCPP). For the upcoming search, the site will begin making<br>
      offers at
      <input name="site_ao-op-mfs-at" type="text" size="15">
      <em>DATE FORMAT: MM/DD/YYYY</em>. </td>
  </tr>
  <tr>
    <td colspan="2"><div align="right">
        <input name="site_ao-op-mfs-b" type="text" size="3">
    </div></td>
    <td colspan="4">The site does not abide by the timeline established by ACATCPP (i.e., offers may be made any<br>
      time during the application process). </td>
  </tr>
  <tr>
    <td colspan="2"><div align="right">&nbsp;</div></td>
    <td colspan="4"><em>Note: Unlike PsyD and MA Clinical students, MA Forensic students CAN accept an offer<br>
      any time throughout the year. </em></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td colspan="5"><strong>MA I/O Sites (Y/N) </strong></td>
  </tr>
  <tr>
    <td colspan="2"><div align="right">
        <input name="site_ao-op-mis-a" type="text" size="3">
    </div></td>
    <td colspan="4">The site offers positions to preferred candidates. </td>
  </tr>
  <tr>
    <td colspan="2"><div align="right">
        <input name="site_ao-op-mis-b" type="text" size="3">
    </div></td>
    <td colspan="4">The Office of Placement &amp; Training offers positions to preferred candidates on behalf of the<br>
      site. </td>
  </tr>
</table>
<br>
<table width="780" border="0">
    <tr>
    <td colspan="6"><strong>Clientele Details</strong>
(Y/N)
  </td>
  </tr>
  <tr>
    <td colspan="6"><strong>Age</strong></td>
  </tr>
  <tr>
    <td><input name="site_cd-a-ps" type="text" size="3"></td>
    <td>Pre-School (3-5) </td>
    <td><input name="site_cd-a-sa" type="text" size="3"></td>
    <td>School Age (6-12) </td>
    <td><input name="site_cd-a-ad" type="text" size="3"></td>
    <td>Adolescents</td>
  </tr>
  <tr>
    <td><input name="site_cd-a-au" type="text" size="3"></td>
    <td>Adults (18-64) </td>
    <td><input name="site_cd-a-oa" type="text" size="3"></td>
    <td>Older Adults (65+)</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Gender</strong></td>
  </tr>
  <tr>
    <td><input name="site_cd-g-f" type="text" size="3"></td>
    <td>Females</td>
    <td><input name="site_cd-g-m" type="text" size="3"></td>
    <td>Males</td>
    <td><input name="site_cd-g-t" type="text" size="3"></td>
    <td>Transgendered</td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Sexual Orientation </strong></td>
  </tr>
  <tr>
    <td><input name="site_cd-so-b" type="text" size="3"></td>
    <td>Bisexual</td>
    <td><input name="site_cd-so-g" type="text" size="3"></td>
    <td>Gay</td>
    <td><input name="site_cd-so-h" type="text" size="3"></td>
    <td>Heterosexual</td>
  </tr>
  <tr>
    <td><input name="site_cd-so-l" type="text" size="3"></td>
    <td>Lesbian</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Ethnicity</strong></td>
  </tr>
  <tr>
    <td><input name="site_cd-e-aabao" type="text" size="3"></td>
    <td>African-American / Black / <br>
      African Origin </td>
    <td><input name="site_cd-e-aianao" type="text" size="3"></td>
    <td>American Indian / Alaska <br>
      Native / Aboriginal Canadian</td>
    <td><input name="site_cd-e-aaaop" type="text" size="3"></td>
    <td>Asian-American / Asian <br>
      Origin / Pacific Islander </td>
  </tr>
  <tr>
    <td><input name="site_cd-e-brmr" type="text" size="3"></td>
    <td>Bi-Racial / Multi-Racial </td>
    <td><input name="site_cd-e-eow" type="text" size="3"></td>
    <td>European Origin / White </td>
    <td><input name="site_cd-e-lh" type="text" size="3"></td>
    <td>Latino-a/Hispanic</td>
  </tr>
  <tr>
    <td><input name="site_cd-e-other" type="text" size="3"></td>
    <td>Other</td>
    <td colspan="4"><input name="site_cd-e-othert" type="text" size="40"></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Disability</strong></td>
  </tr>
  <tr>
    <td><input name="site_cd-d-bvi" type="text" size="3"></td>
    <td>Blind/Visually Impaired </td>
    <td><input name="site_cd-d-dhh" type="text" size="3"></td>
    <td>Deaf/Hard of Hearing </td>
    <td><input name="site_cd-d-dd" type="text" size="3"></td>
    <td>Developmental Disability </td>
  </tr>
  <tr>
    <td><input name="site_cd-d-lcd" type="text" size="3"></td>
    <td>Learning/Cognitive Disability </td>
    <td><input name="site_cd-d-smi" type="text" size="3"></td>
    <td>Severe Mental Illness </td>
    <td><input name="site_cd-d-pod" type="text" size="3"></td>
    <td>Physical/Orthopedic Disability</td>
  </tr>
  <tr>
    <td><input name="site_cd-d-other" type="text" size="3"></td>
    <td>Other</td>
    <td colspan="4"><input name="site_cd-d-othert" type="text" size="40"></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Mental Disorders </strong></td>
  </tr>
  <tr>
    <td><input name="site_cd-md-mr" type="text" size="3"></td>
    <td>Mental Retardation </td>
    <td><input name="site_cd-md-l" type="text" size="3"></td>
    <td>Learning</td>
    <td><input name="site_cd-md-ms" type="text" size="3"></td>
    <td>Motor Skills </td>
  </tr>
  <tr>
    <td><input name="site_cd-md-c" type="text" size="3"></td>
    <td>Communication</td>
    <td><input name="site_cd-md-pd" type="text" size="3"></td>
    <td>Pervasive Developmental</td>
    <td><input name="site_cd-md-addb" type="text" size="3"></td>
    <td>Attention-Deficit &amp; Disruptive<br>
      Behavior</td>
  </tr>
  <tr>
    <td><input name="site_cd-md-de" type="text" size="3"></td>
    <td>Dementia</td>
    <td><input name="site_cd-md-sr" type="text" size="3"></td>
    <td>Substance-Related</td>
    <td><input name="site_cd-md-sop" type="text" size="3"></td>
    <td>Schizophrenia &amp; Other Psychotic </td>
  </tr>
  <tr>
    <td><input name="site_cd-md-m" type="text" size="3"></td>
    <td>Mood</td>
    <td><input name="site_cd-md-an" type="text" size="3"></td>
    <td>Anxiety</td>
    <td><input name="site_cd-md-di" type="text" size="3"></td>
    <td>Dissociative</td>
  </tr>
  <tr>
    <td><input name="site_cd-md-se" type="text" size="3"></td>
    <td>Sexual</td>
    <td><input name="site_cd-md-e" type="text" size="3"></td>
    <td>Eating</td>
    <td><input name="site_cd-md-sl" type="text" size="3"></td>
    <td>Sleep</td>
  </tr>
  <tr>
    <td><input name="site_cd-md-ic" type="text" size="3"></td>
    <td>Impluse-Control</td>
    <td><input name="site_cd-md-ad" type="text" size="3"></td>
    <td>Adjustment</td>
    <td><input name="site_cd-md-p" type="text" size="3"></td>
    <td>Personality</td>
  </tr>
  <tr>
    <td><input name="site_cd-md-other" type="text" size="3"></td>
    <td>Other</td>
    <td colspan="4"><input name="site_cd-md-othert" type="text" size="40"></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>SES</strong></td>
  </tr>
  <tr>
    <td><input name="site_cd-ses-l" type="text" size="3"></td>
    <td>Low SES </td>
    <td><input name="site_cd-ses-m" type="text" size="3"></td>
    <td>Middle SES </td>
    <td><input name="site_cd-ses-h" type="text" size="3"></td>
    <td>High SES </td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Religion</strong></td>
  </tr>
  <tr>
    <td><input name="site_cd-r-bu" type="text" size="3"></td>
    <td>Buddhist</td>
    <td><input name="site_cd-r-c" type="text" size="3"></td>
    <td>Christian</td>
    <td><input name="site_cd-f-h" type="text" size="3"></td>
    <td>Hindu</td>
  </tr>
  <tr>
    <td><input name="site_cd-r-j" type="text" size="3"></td>
    <td>Jewish</td>
    <td><input name="site_cd-r-m" type="text" size="3"></td>
    <td>Muslim</td>
    <td><input name="site_cd-r-ba" type="text" size="3"></td>
    <td>Baha'i</td>
  </tr>
  <tr>
    <td><input name="site_cd-r-other" type="text" size="3"></td>
    <td>Other</td>
    <td colspan="4"><input name="site_cd-r-othert" type="text" size="40"></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>International &amp; Refugee</strong></td>
  </tr>
  <tr>
    <td colspan="6"><textarea name="site_cd-ir" cols="50" rows="5"></textarea></td>
  </tr>
  <tr>
    <td colspan="6">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="6"><strong>Languages Spoken </strong></td>
  </tr>
  <tr>
    <td><input name="site_cd-ls-e" type="text" size="3"></td>
    <td>English</td>
    <td><input name="site_cd-ls-s" type="text" size="3"></td>
    <td>Spanish</td>
    <td>&

__________________
Michael W. Vollmer

Do you really have that many fields in a single table?

I can't imagine anyone is going to be that much of an altruist to wade through all that code. You would be better off just posting the result of Response.Write query. Also, have you tried taking the SQL from Response.Write query and pasting it into a new query in Access? You will often get more helpful info that way.

rgds
Phil

This is the sql statement that is being generated, along witht the exact error I am recieving:

INSERT INTO sites ([site_code], [site_pi-osd], [site_pi-ssd], [site_pi-su-sm], [site_pi-su-em], [site_pi-su-nm], [site_pi-fa-sm], [site_pi-fa-em], [site_pi-fa-nm], [site_pi-sp-sm], [site_pi-sp-em], [site_pi-sp-nm], [site_pi-su-fs], [site_pi-su-fe], [site_pi-fa-fs], [site_pi-fa-fe], [site_pi-sp-fs], [site_pi-sp-fe], [site_pi-su-adw], [site_pi-fa-adw], [site_pi-sp-adw], [site_pi-su-ahw], [site_pi-fa-ahw], [site_pi-sp-ahw], [site_pi-su-ath], [site_pi-fa-ath], [site_pi-sp-ath], [site_pi-rtd-mo], [site_pi-rtd-tu], [site_pi-rtd-we], [site_pi-rtd-th], [site_pi-rtd-fr], [site_pi-rtd-sa], [site_pi-rtd-su], [site_pi-wta], [site_pi-ea], [site_pi-ben-stp], [site_pi-ben-per], [site_pi-ben-vdy], [site_pi-dic], [site_pi-pd], [site_pi-hpp], [site_pi-pc-ca], [site_pi-pc-ec], [site_pi-pc-or], [site_pi-pc-he], [site_pi-pc-mc], [site_pi-pc-fo], [site_sp-cd], [site_ta-cfia-itc], [site_ta-cfia-gtc], [site_ta-cfia-ftc], [site_ta-cfia-ctc], [site_ta-cfia-cc], [site_ta-cfia-sc], [site_ta-cfia-mt], [site_ta-cfia-ci], [site_ta-cfia-cm], [site_ta-cfia-mhi], [site_ta-cfia-sai], [site_ta-cfia-pd], [site_ta-cfia-op], [site_ta-cfia-sp], [site_ta-cfia-cla], [site_ta-cfia-sos], [site_ta-cfia-ot], [site_ta-cfaa-ii], [site_ta-cfaa-si], [site_ta-cfaa-dci], [site_ta-cfaa-mse], [site_ta-cfaa-pt], [site_ta-cfaa-ot], [site_ta-cfaa-srm], [site_ta-cfaa-it], [site_ta-cfaa-ldt], [site_ta-cfaa-aat], [site_ta-cfaa-nt], [site_ta-cfaa-othert], [site_ta-ios-ic], [site_ta-ios-ec], [site_ta-ios-hr], [site_ta-ioa-rps], [site_ta-ioa-in], [site_ta-ioa-ja], [site_ta-ioa-jd], [site_ta-ioa-fg], [site_ta-ioa-sdd], [site_ta-ioa-cc], [site_ta-ioa-mr], [site_ta-ioa-sp], [site_ta-ioa-tdd], [site_ta-ioa-ic], [site_ta-ioa-shp], [site_ta-ioa-aap], [site_ta-ioa-pm], [site_ta-ioa-cba], [site_ta-ioa-other], [site_ro-roa], [site_ro-roat], [site_tp-hisw], [site_tp-hgsw], [site_tp-olea], [site_tp-tp], [site_ao-am-cl], [site_ao-am-rcv], [site_ao-am-lr], [site_ao-am-lrn], [site_ao-am-tr], [site_ao-am-saf], [site_ao-am-safh], [site_ao-am-bc], [site_ao-am-ws], [site_ao-am-other], [site_ao-mpc-a1], [site_ao-mpc-a], [site_ao-mpc-b1], [site_ao-mpc-ba], [site_ao-mpc-bb], [site_ao-mpc-bc], [site_ao-mpc-c1], [site_ao-mpc-c], [site_ao-mpc-d1], [site_ao-ip-a], [site_ao-ip-b], [site_ao-op-pmcs-a], [site_ao-op-pmcs-at], [site_ao-op-pmcs-b], [site_ao-op-pmcs-c], [site_ao-op-mfs-a], [site_ao-op-mfs-at], [site_ao-op-mfs-b], [site_ao-op-mis-a], [site_ao-op-mis-b], [site_cd-a-ps], [site_cd-a-sa], [site_cd-a-ad], [site_cd-a-au], [site_cd-a-oa], [site_cd-g-f], [site_cd-g-m], [site_cd-g-t], [site_cd-so-b], [site_cd-so-g], [site_cd-so-h], [site_cd-so-l], [site_cd-e-aabao], [site_cd-e-aianao], [site_cd-e-aaaop], [site_cd-e-brmr], [site_cd-e-eow], [site_cd-e-lh], [site_cd-e-other], [site_cd-e-othert], [site_cd-d-bvi], [site_cd-d-dhh], [site_cd-d-dd], [site_cd-d-lcd], [site_cd-d-smi], [site_cd-d-pod], [site_cd-d-other], [site_cd-d-othert], [site_cd-md-mr], [site_cd-md-l], [site_cd-md-ms], [site_cd-md-c], [site_cd-md-pd], [site_cd-md-addb], [site_cd-md-de], [site_cd-md-sr], [site_cd-md-sop], [site_cd-md-m], [site_cd-md-an], [site_cd-md-di], [site_cd-md-se], [site_cd-md-e], [site_cd-md-sl], [site_cd-md-ic], [site_cd-md-ad], [site_cd-md-p], [site_cd-md-other], [site_cd-md-othert], [site_cd-ses-l], [site_cd-ses-m], [site_cd-ses-h], [site_cd-r-bu], [site_cd-r-c], [site_cd-r-h], [site_cd-r-j], [site_cd-r-m], [site_cd-r-ba], [site_cd-r-other], [site_cd-r-othert], [site_cd-ir], [site_cd-ls-e], [site_cd-ls-s], [site_cd-ls-o], [site_aad-bg], [site_aad-cpir], [site_aad-cs], [site_aad-hpcr], [site_aad-hr], [site_aad-mcmi], [site_aad-mmpia], [site_aad-mmpii], [site_aad-mbii], [site_aad-prm], [site_aad-ppvt], [site_aad-pai], [site_aad-pd], [site_aad-ps], [site_aad-r], [site_aad-srm], [site_aad-sii], [site_aad-sdi], [site_aad-tat], [site_aad-tmt], [site_aad-v], [site_aad-wais], [site_aad-wmsi], [site_aad-wisc], [site_aad-wppsi], [site_aad-wrat], [site_aad-other], [site_aad-othert], [site_aad-as], [site_aad-ts], [site_aad-ads]) values ('2', 'y', 'n', 'Jan', 'Feb', '2', 'March', 'May', '3', 'June', 'December', '7', 'y', 'y', 'n', 'n', 'n', 'n', '8', '8', '8', '8', '8', '8', '8', '8', '8', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', '7', 'hour', '8', 'test', 'test', 'www.test.com', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'test', '8', '8', 'test', 'test', 'y', 'y', 'y', '8', 'y', 'y', 'test', 'y', 'test', 'test', 'y', '12/12/2003', 'y', 'y', 'y', 'y', 'y', '12/12/2003', 'y', 'y', 'y', 'y', '12/12/2003', 'y', '12/12/2003', 'y', '12/12/2003', 'y', 'y', 'y' y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'test', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', '8', '8', '8')
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''y' y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'test', 'y', ''.

/portal/Portal/practicum2/admin_sites-add_exe3.asp, line 471


Michael W. Vollmer

Phil is right, try pasting it into a new query in Access...

And did you try pasting it into a new query in Access and running it from there?

There is an error... Jacob.

... and I will tell you where...  Jacob.

And it stems from here:
  & Request.Form("site_ao-op-mis-b") & "' " _