Re: Timeout with Where statement

From: Frank Petrucci (fpetrucci007_at_yahoo.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 05:31:03 -0700

Thanks Val. I will try creating some indexes. By the way the query works when I run it from an MS Access query using an odbc connector but not when I run a query using SQL Enterprise Manager.

Relevant Pages

  • RE: Access query vs. Excel query
    ... I have created a second sheet in the Excel workbook with another query for a different purpose. ... At first, I copied the sql from the Access query and pasted into MSQuery to attempt to just duplicate the data there, but ran into a problem. ...
    (microsoft.public.excel.programming)
  • Re: Data source
    ... This is really an Access query design question. ... In your Access datasource ... you need a field by which you can link each record the the Setup ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Access Query w/VBScript
    ... > Something interesting I've found regarding running the Access query. ... > If the Access query is SELECT tblEmployees.* FROM tblEmployees, ... > ASP page works as I hoped. ...
    (microsoft.public.scripting.vbscript)
  • Re: SUBQUERIES in the FROM clause with Access query
    ... > I have this long query that extract datas from 12 tables, ... > there are 8 subqueries, it work fine with pass-thru, but now this query ... > Table4 fileds: code, code_desc ... > Can anyone help me how to put this in ACCESS query? ...
    (microsoft.public.access.queries)
  • Re: Access vs. Excel query w/blank field
    ... These queries are not "identical." ... I you changed the "LEFT JOIN" in Access query ... Is there any reason you cannot rewrite your Excel ...
    (microsoft.public.access.queries)