title: Error 3078 "cannot find table" in MS Access from external ODBC-linked table
body: <p>Within my Access 2010 form I have the ability to add records, but before one adds a record, we need the ability to check if the business unit, year, and quarter already exists within the SQL table before new record is being written.</p>
  
  <p>The three things I need to confirm are the fields in my form called [BU_Selected_Add], [Qtr_Add] and [Year_Add] in the SQL table "tTbl_ADMIN_RxREBATE" within their respective fields:
  [GL_BU], [Year], and [Quarter].
  So I started with a simple Business_Unit dlookup below:</p>
  
  <pre><code> If DLookup("[GL_BU]", "tTbl_ADMIN_RxREBATE", "[GL_BU] = '" &amp; 
   Me!BU_Selected_Add &amp; "'") &gt; 0 Then
   MsgBox "This Business Unit already exists within the data below!"
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>Run-time error '3078': The Microsoft Access database engine cannot find the 
  input table or query "tTbl_ADMIN_RxRebate".  Make sure it exists and that its 
  name is spelled correctly.
  </code></pre>
  
  <p>It most certainly exists in the SQL Server 2008 R2.</p>
  
  <p>I need to get this first part right before adding in whether that [BU_Selected_Add] was added during the year and quarter within the fieldboxes called [Qtr_Add] and [Year_Add].</p>
  
  <pre><code>  SELECT dbo_tTbl_ADMIN_RxREBATE.MSID, dbo_tTbl_ADMIN_RxREBATE.DateAdded,      dbo_tTbl_ADMIN_RxREBATE.Qtr, dbo_tTbl_ADMIN_RxREBATE.Year, dbo_tTbl_ADMIN_RxREBATE.Rpt_Date, dbo_tTbl_ADMIN_RxREBATE.SRVC_TYP_CD, dbo_tTbl_ADMIN_RxREBATE.GL_BU, dbo_BU_Description.[BU Description], dbo_tTbl_ADMIN_RxREBATE.PY_FNL_PICK_AMT, dbo_tTbl_ADMIN_RxREBATE.PY_FNL_MRGN_AMT, dbo_tTbl_ADMIN_RxREBATE.PY_IBNR_AMT, dbo_tTbl_ADMIN_RxREBATE.CY_FNL_PICK_AMT, dbo_tTbl_ADMIN_RxREBATE.CY_FNL_MRGN_AMT, dbo_tTbl_ADMIN_RxREBATE.CY_IBNR_AMT
    FROM dbo_tTbl_ADMIN_RxREBATE INNER JOIN dbo_BU_Description ON       dbo_tTbl_ADMIN_RxREBATE.GL_BU = dbo_BU_Description.BU
    WHERE (((dbo_tTbl_ADMIN_RxREBATE.Qtr)=[Forms]![Frm_Main]![Frm_Main_Combo_Qtr]) AND ((dbo_tTbl_ADMIN_RxREBATE.Year)=[Forms]![Frm_Main]![Frm_Main_Combo_Year]));
  </code></pre>